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.CSI_ML_CREATE_PUB dependencies on FND_API

Line 27: l_commit VARCHAR2(1) := fnd_api.g_false;

23: l_org_assign_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
24: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
25: l_grp_error_tbl CSI_DATASTRUCTURES_PUB.GRP_ERROR_TBL;
26: l_api_version NUMBER := 1.0;
27: l_commit VARCHAR2(1) := fnd_api.g_false;
28: l_init_msg_list VARCHAR2(1) := fnd_api.g_true;
29: l_validation_level NUMBER := fnd_api.g_valid_level_full;
30: l_msg_count NUMBER;
31: l_msg_data VARCHAR2(2000);

Line 28: l_init_msg_list VARCHAR2(1) := fnd_api.g_true;

24: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
25: l_grp_error_tbl CSI_DATASTRUCTURES_PUB.GRP_ERROR_TBL;
26: l_api_version NUMBER := 1.0;
27: l_commit VARCHAR2(1) := fnd_api.g_false;
28: l_init_msg_list VARCHAR2(1) := fnd_api.g_true;
29: l_validation_level NUMBER := fnd_api.g_valid_level_full;
30: l_msg_count NUMBER;
31: l_msg_data VARCHAR2(2000);
32: l_msg_index NUMBER;

Line 29: l_validation_level NUMBER := fnd_api.g_valid_level_full;

25: l_grp_error_tbl CSI_DATASTRUCTURES_PUB.GRP_ERROR_TBL;
26: l_api_version NUMBER := 1.0;
27: l_commit VARCHAR2(1) := fnd_api.g_false;
28: l_init_msg_list VARCHAR2(1) := fnd_api.g_true;
29: l_validation_level NUMBER := fnd_api.g_valid_level_full;
30: l_msg_count NUMBER;
31: l_msg_data VARCHAR2(2000);
32: l_msg_index NUMBER;
33: l_sql_error VARCHAR2(2000);

Line 34: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

30: l_msg_count NUMBER;
31: l_msg_data VARCHAR2(2000);
32: l_msg_index NUMBER;
33: l_sql_error VARCHAR2(2000);
34: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
35: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
36: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
37: l_api_name VARCHAR2(255) :=
38: 'CSI_ML_CREATE_PUB.CREATE_INSTANCES';

Line 35: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;

31: l_msg_data VARCHAR2(2000);
32: l_msg_index NUMBER;
33: l_sql_error VARCHAR2(2000);
34: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
35: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
36: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
37: l_api_name VARCHAR2(255) :=
38: 'CSI_ML_CREATE_PUB.CREATE_INSTANCES';
39: x_count NUMBER := 0;

Line 36: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

32: l_msg_index NUMBER;
33: l_sql_error VARCHAR2(2000);
34: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
35: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
36: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
37: l_api_name VARCHAR2(255) :=
38: 'CSI_ML_CREATE_PUB.CREATE_INSTANCES';
39: x_count NUMBER := 0;
40: l_count NUMBER := 0;

Line 133: RAISE RESOLVE_ERROR; --fnd_api.g_exc_error;

129: l_return_status,
130: l_error_message);
131:
132: IF NOT l_return_status = l_fnd_success THEN
133: RAISE RESOLVE_ERROR; --fnd_api.g_exc_error;
134: END IF;
135: END IF;
136: -- After getting IDs now create PL/SQL Tables
137:

Line 158: RAISE fnd_api.g_exc_error;

154: l_return_status,
155: l_error_message);
156:
157: IF NOT l_return_status = l_fnd_success THEN
158: RAISE fnd_api.g_exc_error;
159: END IF;
160:
161: -- commented the following unnecessary code
162: /*

Line 201: FND_API.G_FALSE);

197: l_msg_index := 1;
198: l_Error_Message := l_Msg_Data;
199: WHILE l_msg_count > 0 LOOP
200: l_Error_Message := l_Error_Message||FND_MSG_PUB.GET(l_msg_index,
201: FND_API.G_FALSE);
202: l_msg_index := l_msg_index + 1;
203: l_Msg_Count := l_Msg_Count - 1;
204: END LOOP;
205: RAISE fnd_api.g_exc_error;

Line 205: RAISE fnd_api.g_exc_error;

201: FND_API.G_FALSE);
202: l_msg_index := l_msg_index + 1;
203: l_Msg_Count := l_Msg_Count - 1;
204: END LOOP;
205: RAISE fnd_api.g_exc_error;
206: END IF;
207:
208: l_tbl_count := 0;
209: l_tbl_count := l_instance_tbl.count;

Line 248: WHEN fnd_api.g_exc_error THEN

244: FND_File.Put_Line(Fnd_File.LOG,l_error_message);
245: END IF;
246: x_return_status := l_fnd_error;
247: x_msg_data := l_error_message;
248: WHEN fnd_api.g_exc_error THEN
249: ROLLBACK to create_instances;
250: IF(l_debug_level>1) THEN
251: FND_File.Put_Line(Fnd_File.LOG,'In EXPECTED Exception in:'||l_api_name);
252: FND_File.Put_Line(Fnd_File.LOG,l_error_message);

Line 295: l_commit VARCHAR2(1) := fnd_api.g_false;

291: l_org_assign_tbl CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL;
292: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
293: l_grp_error_tbl CSI_DATASTRUCTURES_PUB.GRP_ERROR_TBL;
294: l_api_version NUMBER := 1.0;
295: l_commit VARCHAR2(1) := fnd_api.g_false;
296: l_init_msg_list VARCHAR2(1) := fnd_api.g_true;
297: l_validation_level NUMBER := fnd_api.g_valid_level_full;
298: l_msg_count NUMBER;
299: l_msg_data VARCHAR2(2000);

Line 296: l_init_msg_list VARCHAR2(1) := fnd_api.g_true;

292: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_TBL;
293: l_grp_error_tbl CSI_DATASTRUCTURES_PUB.GRP_ERROR_TBL;
294: l_api_version NUMBER := 1.0;
295: l_commit VARCHAR2(1) := fnd_api.g_false;
296: l_init_msg_list VARCHAR2(1) := fnd_api.g_true;
297: l_validation_level NUMBER := fnd_api.g_valid_level_full;
298: l_msg_count NUMBER;
299: l_msg_data VARCHAR2(2000);
300: l_msg_index NUMBER;

Line 297: l_validation_level NUMBER := fnd_api.g_valid_level_full;

293: l_grp_error_tbl CSI_DATASTRUCTURES_PUB.GRP_ERROR_TBL;
294: l_api_version NUMBER := 1.0;
295: l_commit VARCHAR2(1) := fnd_api.g_false;
296: l_init_msg_list VARCHAR2(1) := fnd_api.g_true;
297: l_validation_level NUMBER := fnd_api.g_valid_level_full;
298: l_msg_count NUMBER;
299: l_msg_data VARCHAR2(2000);
300: l_msg_index NUMBER;
301: l_sql_error VARCHAR2(2000);

Line 302: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

298: l_msg_count NUMBER;
299: l_msg_data VARCHAR2(2000);
300: l_msg_index NUMBER;
301: l_sql_error VARCHAR2(2000);
302: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
303: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
304: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
305: l_api_name VARCHAR2(255) :=
306: 'CSI_ML_CREATE_PUB.CREATE_PARALLEL_INSTANCES';

Line 303: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;

299: l_msg_data VARCHAR2(2000);
300: l_msg_index NUMBER;
301: l_sql_error VARCHAR2(2000);
302: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
303: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
304: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
305: l_api_name VARCHAR2(255) :=
306: 'CSI_ML_CREATE_PUB.CREATE_PARALLEL_INSTANCES';
307: x_count NUMBER := 0;

Line 304: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

300: l_msg_index NUMBER;
301: l_sql_error VARCHAR2(2000);
302: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
303: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
304: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
305: l_api_name VARCHAR2(255) :=
306: 'CSI_ML_CREATE_PUB.CREATE_PARALLEL_INSTANCES';
307: x_count NUMBER := 0;
308: l_count NUMBER := 0;

Line 446: RAISE RESOLVE_ERROR; --fnd_api.g_exc_error;

442: to_char(sysdate,'DD-MON-YYYY HH:MI:SS:SS'));
443: END IF;
444:
445: IF NOT l_return_status = l_fnd_success THEN
446: RAISE RESOLVE_ERROR; --fnd_api.g_exc_error;
447: END IF;
448: END IF;
449:
450: -- After getting IDs now create PL/SQL Tables

Line 480: RAISE fnd_api.g_exc_error;

476: to_char(sysdate,'DD-MON-YYYY HH:MI:SS:SS'));
477: END IF;
478:
479: IF NOT l_return_status = l_fnd_success THEN
480: RAISE fnd_api.g_exc_error;
481: END IF;
482:
483: IF(l_debug_level>1) THEN
484: FND_File.Put_Line(Fnd_File.LOG,'Before Contact Loop: '||

Line 535: FND_API.G_FALSE);

531: l_msg_index := 1;
532: l_Error_Message := l_Msg_Data;
533: WHILE l_msg_count > 0 LOOP
534: l_Error_Message := l_Error_Message||FND_MSG_PUB.GET(l_msg_index,
535: FND_API.G_FALSE);
536: l_msg_index := l_msg_index + 1;
537: l_Msg_Count := l_Msg_Count - 1;
538: END LOOP;
539: RAISE fnd_api.g_exc_error;

Line 539: RAISE fnd_api.g_exc_error;

535: FND_API.G_FALSE);
536: l_msg_index := l_msg_index + 1;
537: l_Msg_Count := l_Msg_Count - 1;
538: END LOOP;
539: RAISE fnd_api.g_exc_error;
540: END IF;
541: IF(l_debug_level>1) THEN
542: FND_File.Put_Line(Fnd_File.LOG,'After GRP API: '||
543: to_char(sysdate,'DD-MON-YYYY HH:MI:SS:SS'));

Line 563: WHEN fnd_api.g_exc_error THEN

559: COMMIT;
560:
561: -- Bug 11073343
562: EXCEPTION
563: WHEN fnd_api.g_exc_error THEN
564: ROLLBACK to create_parallel_instances;
565:
566: IF(l_debug_level>1) THEN
567: FND_File.Put_Line(Fnd_File.LOG,'In Inner Loop Exception in:'||l_api_name);

Line 612: WHEN fnd_api.g_exc_error THEN

608: WHERE inst_interface_id = l_inst_id_tbl(j).inst_interface_id;
609:
610: END LOOP;
611: COMMIT;
612: WHEN fnd_api.g_exc_error THEN
613: ROLLBACK to OUTER_LOOP_CR_PARALLEL_INST;
614:
615: IF(l_debug_level>1) THEN
616: FND_File.Put_Line(Fnd_File.LOG,'In EXPECTED Exception in:'||l_api_name);

Line 671: l_commit VARCHAR2(1) := fnd_api.g_false;

667: l_relationship_tbl CSI_DATASTRUCTURES_PUB.II_RELATIONSHIP_TBL;
668: l_txn_tbl CSI_DATASTRUCTURES_PUB.TRANSACTION_TBL;
669: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
670: l_api_version NUMBER := 1.0;
671: l_commit VARCHAR2(1) := fnd_api.g_false;
672: l_init_msg_list VARCHAR2(1) := fnd_api.g_true;
673: l_validation_level NUMBER := fnd_api.g_valid_level_full;
674: l_msg_count NUMBER;
675: l_msg_data VARCHAR2(2000);

Line 672: l_init_msg_list VARCHAR2(1) := fnd_api.g_true;

668: l_txn_tbl CSI_DATASTRUCTURES_PUB.TRANSACTION_TBL;
669: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
670: l_api_version NUMBER := 1.0;
671: l_commit VARCHAR2(1) := fnd_api.g_false;
672: l_init_msg_list VARCHAR2(1) := fnd_api.g_true;
673: l_validation_level NUMBER := fnd_api.g_valid_level_full;
674: l_msg_count NUMBER;
675: l_msg_data VARCHAR2(2000);
676: l_msg_index NUMBER;

Line 673: l_validation_level NUMBER := fnd_api.g_valid_level_full;

669: l_txn_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_REC;
670: l_api_version NUMBER := 1.0;
671: l_commit VARCHAR2(1) := fnd_api.g_false;
672: l_init_msg_list VARCHAR2(1) := fnd_api.g_true;
673: l_validation_level NUMBER := fnd_api.g_valid_level_full;
674: l_msg_count NUMBER;
675: l_msg_data VARCHAR2(2000);
676: l_msg_index NUMBER;
677: l_sql_error VARCHAR2(2000);

Line 678: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

674: l_msg_count NUMBER;
675: l_msg_data VARCHAR2(2000);
676: l_msg_index NUMBER;
677: l_sql_error VARCHAR2(2000);
678: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
679: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
680: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
681: l_api_name VARCHAR2(255) :=
682: 'CSI_ML_CREATE_PUB.CREATE_RELATIONSHIPS';

Line 679: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;

675: l_msg_data VARCHAR2(2000);
676: l_msg_index NUMBER;
677: l_sql_error VARCHAR2(2000);
678: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
679: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
680: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
681: l_api_name VARCHAR2(255) :=
682: 'CSI_ML_CREATE_PUB.CREATE_RELATIONSHIPS';
683: x_count NUMBER := 0;

Line 680: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

676: l_msg_index NUMBER;
677: l_sql_error VARCHAR2(2000);
678: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
679: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
680: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
681: l_api_name VARCHAR2(255) :=
682: 'CSI_ML_CREATE_PUB.CREATE_RELATIONSHIPS';
683: x_count NUMBER := 0;
684: l_count NUMBER := 0;

Line 698: WHEN fnd_api.g_exc_error THEN

694:
695: x_return_status := l_fnd_success;
696:
697: EXCEPTION
698: WHEN fnd_api.g_exc_error THEN
699: ROLLBACK to create_relationships;
700:
701: IF(l_debug_level>1) THEN
702: FND_File.Put_Line(Fnd_File.LOG,'In EXPECTED Exception in:'||l_api_name);