eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_IMPORT_CLIENT_PVT dependencies on FND_API

Line 17: p_insert_flag IN VARCHAR2 := FND_API.G_FALSE, --TRUE for insertion

13: PROCEDURE Init_Col_Data (
14: p_data IN CN_IMPORT_PVT.char_data_set_type,
15: p_start_index IN NUMBER,
16: p_end_index IN NUMBER,
17: p_insert_flag IN VARCHAR2 := FND_API.G_FALSE, --TRUE for insertion
18: p_col_data IN OUT NOCOPY JTF_VARCHAR2_TABLE_2000
19: );
20:
21: PROCEDURE Append_More_Data (

Line 35: p_insert_flag IN VARCHAR2 := FND_API.G_FALSE, --TRUE for insertion

31: p_start_index IN NUMBER,
32: p_col_count IN NUMBER,
33: p_row_count IN NUMBER,
34: p_data IN CN_IMPORT_PVT.char_data_set_type,
35: p_insert_flag IN VARCHAR2 := FND_API.G_FALSE, --TRUE for insertion
36: p_col1_data IN OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
37: p_col2_data IN OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
38: p_col3_data IN OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
39: p_col4_data IN OUT NOCOPY JTF_VARCHAR2_TABLE_2000,

Line 228: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

224: -- NOTES
225:
226: PROCEDURE Insert_Data
227: (p_api_version IN NUMBER,
228: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
229: p_commit IN VARCHAR2 := FND_API.G_FALSE,
230: p_imp_header_id IN NUMBER,
231: p_import_type_code IN VARCHAR2,
232: p_table_name IN VARCHAR2,

Line 229: p_commit IN VARCHAR2 := FND_API.G_FALSE,

225:
226: PROCEDURE Insert_Data
227: (p_api_version IN NUMBER,
228: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
229: p_commit IN VARCHAR2 := FND_API.G_FALSE,
230: p_imp_header_id IN NUMBER,
231: p_import_type_code IN VARCHAR2,
232: p_table_name IN VARCHAR2,
233: p_col_names IN CN_IMPORT_PVT.char_data_set_type,

Line 325: IF NOT FND_API.compatible_api_call

321:
322: -- Standard Start of API savepoint
323: SAVEPOINT Insert_Data;
324: -- Standard call to check for call compatibility.
325: IF NOT FND_API.compatible_api_call
326: ( l_api_version ,p_api_version ,l_api_name ,G_PKG_NAME )
327: THEN
328: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
329: END IF;

Line 328: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

324: -- Standard call to check for call compatibility.
325: IF NOT FND_API.compatible_api_call
326: ( l_api_version ,p_api_version ,l_api_name ,G_PKG_NAME )
327: THEN
328: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
329: END IF;
330: -- Initialize message list if p_init_msg_list is set to TRUE.
331: IF FND_API.to_Boolean( p_init_msg_list ) THEN
332: FND_MSG_PUB.initialize;

Line 331: IF FND_API.to_Boolean( p_init_msg_list ) THEN

327: THEN
328: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
329: END IF;
330: -- Initialize message list if p_init_msg_list is set to TRUE.
331: IF FND_API.to_Boolean( p_init_msg_list ) THEN
332: FND_MSG_PUB.initialize;
333: END IF;
334: -- Initialize API return status to success
335: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 335: x_return_status := FND_API.G_RET_STS_SUCCESS;

331: IF FND_API.to_Boolean( p_init_msg_list ) THEN
332: FND_MSG_PUB.initialize;
333: END IF;
334: -- Initialize API return status to success
335: x_return_status := FND_API.G_RET_STS_SUCCESS;
336: -- API body
337: cn_message_pkg.debug('Insert Data : Start Inserting Data');
338:
339: l_orig_col_count := p_col_names.COUNT;

Line 343: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

339: l_orig_col_count := p_col_names.COUNT;
340:
341: IF l_orig_col_count < 1 THEN
342: cn_message_pkg.set_error(l_api_name,'Column count < 1');
343: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
344: END IF;
345:
346: cn_message_pkg.debug('Insert Data : Start Copy Data from p_data');
347:

Line 394: p_insert_flag => FND_API.G_TRUE,

390: p_col37_data => l_col37_data,
391: p_col38_data => l_col38_data,
392: p_col39_data => l_col39_data,
393: p_col40_data => l_col40_data,
394: p_insert_flag => FND_API.G_TRUE,
395: p_act_col_num => l_act_col_count);
396:
397: cn_message_pkg.debug('Insert Data : Finish Copy Data from p_data');
398:

Line 501: IF x_return_status <> FND_API.g_ret_sts_success THEN

497: x_msg_count => x_msg_count,
498: x_msg_data => x_msg_data);
499:
500: -- If any errors happen abort API.
501: IF x_return_status <> FND_API.g_ret_sts_success THEN
502: RAISE FND_API.G_EXC_ERROR;
503: END IF;
504:
505: cn_message_pkg.debug('Insert Data : Finish insert into DB');

Line 502: RAISE FND_API.G_EXC_ERROR;

498: x_msg_data => x_msg_data);
499:
500: -- If any errors happen abort API.
501: IF x_return_status <> FND_API.g_ret_sts_success THEN
502: RAISE FND_API.G_EXC_ERROR;
503: END IF;
504:
505: cn_message_pkg.debug('Insert Data : Finish insert into DB');
506:

Line 559: p_insert_flag => FND_API.G_FALSE,

555: p_col37_data => l_col37_data,
556: p_col38_data => l_col38_data,
557: p_col39_data => l_col39_data,
558: p_col40_data => l_col40_data,
559: p_insert_flag => FND_API.G_FALSE,
560: p_act_col_num => l_act_col_count);
561:
562: cn_message_pkg.debug('Insert Data : Update more data from p_data.');
563:

Line 620: IF x_return_status <> FND_API.g_ret_sts_success THEN

616: x_msg_data => x_msg_data
617: );
618:
619: -- If any errors happen abort API.
620: IF x_return_status <> FND_API.g_ret_sts_success THEN
621: RAISE FND_API.G_EXC_ERROR;
622: END IF;
623:
624: l_col_count := l_col_count + l_act_col_count;

Line 621: RAISE FND_API.G_EXC_ERROR;

617: );
618:
619: -- If any errors happen abort API.
620: IF x_return_status <> FND_API.g_ret_sts_success THEN
621: RAISE FND_API.G_EXC_ERROR;
622: END IF;
623:
624: l_col_count := l_col_count + l_act_col_count;
625:

Line 633: IF FND_API.To_Boolean( p_commit ) THEN

629:
630: -- End of API body.
631:
632: -- Standard check of p_commit.
633: IF FND_API.To_Boolean( p_commit ) THEN
634: COMMIT WORK;
635: END IF;
636: -- Standard call to get message count and if count is 1, get message info.
637: FND_MSG_PUB.count_and_get

Line 640: p_encoded => FND_API.G_FALSE

636: -- Standard call to get message count and if count is 1, get message info.
637: FND_MSG_PUB.count_and_get
638: (p_count => x_msg_count ,
639: p_data => x_msg_data ,
640: p_encoded => FND_API.G_FALSE
641: );
642:
643: EXCEPTION
644: WHEN FND_API.G_EXC_ERROR THEN

Line 644: WHEN FND_API.G_EXC_ERROR THEN

640: p_encoded => FND_API.G_FALSE
641: );
642:
643: EXCEPTION
644: WHEN FND_API.G_EXC_ERROR THEN
645: ROLLBACK TO Insert_Data;
646: x_return_status := FND_API.G_RET_STS_ERROR;
647: FND_MSG_PUB.count_and_get
648: (p_count => x_msg_count,

Line 646: x_return_status := FND_API.G_RET_STS_ERROR;

642:
643: EXCEPTION
644: WHEN FND_API.G_EXC_ERROR THEN
645: ROLLBACK TO Insert_Data;
646: x_return_status := FND_API.G_RET_STS_ERROR;
647: FND_MSG_PUB.count_and_get
648: (p_count => x_msg_count,
649: p_data => x_msg_data
650: );

Line 651: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

647: FND_MSG_PUB.count_and_get
648: (p_count => x_msg_count,
649: p_data => x_msg_data
650: );
651: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
652: ROLLBACK TO Insert_Data;
653: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
654: FND_MSG_PUB.Count_And_Get
655: (p_count => x_msg_count,

Line 653: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

649: p_data => x_msg_data
650: );
651: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
652: ROLLBACK TO Insert_Data;
653: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
654: FND_MSG_PUB.Count_And_Get
655: (p_count => x_msg_count,
656: p_data => x_msg_data
657: );

Line 660: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

656: p_data => x_msg_data
657: );
658: WHEN OTHERS THEN
659: ROLLBACK TO Insert_Data;
660: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
661: cn_message_pkg.set_error(l_api_name,'Unexpected Error.');
662: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
663: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
664: END IF;

Line 669: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

665: FND_MSG_PUB.Count_And_Get (
666: p_count => x_msg_count,
667: p_data => x_msg_data
668: );
669: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
670: END Insert_Data;
671:
672:
673: -- NAME

Line 718: p_insert_flag IN VARCHAR2 := FND_API.G_FALSE, --TRUE for insertion

714: PROCEDURE Init_Col_Data (
715: p_data IN CN_IMPORT_PVT.char_data_set_type,
716: p_start_index IN NUMBER,
717: p_end_index IN NUMBER,
718: p_insert_flag IN VARCHAR2 := FND_API.G_FALSE, --TRUE for insertion
719: p_col_data IN OUT NOCOPY JTF_VARCHAR2_TABLE_2000
720: )
721: IS
722: l_count NUMBER := 1;

Line 724: IF p_insert_flag = FND_API.G_TRUE THEN

720: )
721: IS
722: l_count NUMBER := 1;
723: BEGIN
724: IF p_insert_flag = FND_API.G_TRUE THEN
725: p_col_data := JTF_VARCHAR2_TABLE_2000 ('t');
726: p_col_data.EXTEND (p_end_index - p_start_index, 1);
727: END IF;
728: FOR i IN p_start_index .. p_end_index - 1 LOOP

Line 748: p_insert_flag IN VARCHAR2 := FND_API.G_FALSE, --TRUE for insertion

744: (p_start_index IN NUMBER,
745: p_col_count IN NUMBER,
746: p_row_count IN NUMBER,
747: p_data IN CN_IMPORT_PVT.char_data_set_type,
748: p_insert_flag IN VARCHAR2 := FND_API.G_FALSE, --TRUE for insertion
749: p_col1_data IN OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
750: p_col2_data IN OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
751: p_col3_data IN OUT NOCOPY JTF_VARCHAR2_TABLE_2000,
752: p_col4_data IN OUT NOCOPY JTF_VARCHAR2_TABLE_2000,

Line 1688: p_encoded => FND_API.G_FALSE

1684: -- Standard call to get message count and if count is 1, get message info.
1685: FND_MSG_PUB.Count_And_Get
1686: (p_count => x_msg_count,
1687: p_data => x_msg_data,
1688: p_encoded => FND_API.G_FALSE
1689: );
1690:
1691: EXCEPTION
1692: WHEN OTHERS THEN

Line 1693: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1689: );
1690:
1691: EXCEPTION
1692: WHEN OTHERS THEN
1693: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1694: cn_message_pkg.set_error(l_api_name,'Unexpected Error.');
1695: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1696: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
1697: END IF;

Line 2130: p_encoded => FND_API.G_FALSE

2126: -- Standard call to get message count and if count is 1, get message info.
2127: FND_MSG_PUB.Count_And_Get (
2128: p_count => x_msg_count,
2129: p_data => x_msg_data,
2130: p_encoded => FND_API.G_FALSE
2131: );
2132:
2133: EXCEPTION
2134: WHEN OTHERS THEN

Line 2135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2131: );
2132:
2133: EXCEPTION
2134: WHEN OTHERS THEN
2135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2136: cn_message_pkg.set_error(l_api_name,'Unexpected Error.');
2137: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2138: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
2139: END IF;