DBA Data[Home] [Help]

APPS.CS_GET_CONTRACTS_PUB dependencies on TAPI_DEV_KIT

Line 238: TAPI_DEV_KIT.END_ACTIVITY( p_commit,

234: CLOSE Get_Contracts;
235:
236: p_rec_count := p_rec_count -1;
237:
238: TAPI_DEV_KIT.END_ACTIVITY( p_commit,
239: x_msg_count,
240: x_msg_data);
241:
242: EXCEPTION

Line 244: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS

240: x_msg_data);
241:
242: EXCEPTION
243: WHEN FND_API.G_EXC_ERROR THEN
244: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
245: (
246: l_api_name,
247: G_PKG_NAME,
248: 'FND_API.G_RET_STS_ERROR',

Line 254: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

250: x_msg_data,
251: '_Pvt'
252: );
253: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
254: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
255: (
256: l_api_name,
257: G_PKG_NAME,
258: 'FND_API.G_RET_STS_UNEXP_ERROR',

Line 264: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

260: x_msg_data,
261: '_Pvt'
262: );
263: WHEN OTHERS THEN
264: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
265: (
266: l_api_name,
267: G_PKG_NAME,
268: 'OTHERS',

Line 384: x_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,

380: l_api_version NUMBER := G_API_VERSION;
381:
382: BEGIN
383:
384: x_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
385: G_PKG_NAME,
386: l_api_version,
387: p_api_version,
388: p_init_msg_list,

Line 492: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);

488: p_rec_count := p_rec_count -1;
489:
490: --DBMS_Output.Put_Line('Rec Count='|| to_char(p_rec_count));
491:
492: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
493:
494: EXCEPTION
495: WHEN FND_API.G_EXC_ERROR THEN
496: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS

Line 496: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS

492: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
493:
494: EXCEPTION
495: WHEN FND_API.G_EXC_ERROR THEN
496: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
497: (
498: l_api_name,
499: G_PKG_NAME,
500: 'FND_API.G_RET_STS_ERROR',

Line 506: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

502: x_msg_data,
503: '_Pvt'
504: );
505: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
506: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
507: (
508: l_api_name,
509: G_PKG_NAME,
510: 'FND_API.G_RET_STS_UNEXP_ERROR',

Line 516: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

512: x_msg_data,
513: '_Pvt'
514: );
515: WHEN OTHERS THEN
516: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
517: (
518: l_api_name,
519: G_PKG_NAME,
520: 'OTHERS',

Line 635: x_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,

631: l_api_version NUMBER := G_API_VERSION;
632:
633: BEGIN
634:
635: x_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
636: G_PKG_NAME,
637: l_api_version,
638: p_api_version,
639: p_init_msg_list,

Line 738: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);

734: CLOSE Get_Contracts;
735:
736: p_rec_count := p_rec_count -1;
737:
738: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
739:
740: EXCEPTION
741: WHEN FND_API.G_EXC_ERROR THEN
742: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS

Line 742: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS

738: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
739:
740: EXCEPTION
741: WHEN FND_API.G_EXC_ERROR THEN
742: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
743: (
744: l_api_name,
745: G_PKG_NAME,
746: 'FND_API.G_RET_STS_ERROR',

Line 752: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

748: x_msg_data,
749: '_Pvt'
750: );
751: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
752: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
753: (
754: l_api_name,
755: G_PKG_NAME,
756: 'FND_API.G_RET_STS_UNEXP_ERROR',

Line 762: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

758: x_msg_data,
759: '_Pvt'
760: );
761: WHEN OTHERS THEN
762: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
763: (
764: l_api_name,
765: G_PKG_NAME,
766: 'OTHERS',

Line 827: x_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,

823: l_api_version NUMBER := G_API_VERSION;
824: l_contract_rec_type CONTRACTS_REC_TYPE;
825: BEGIN
826:
827: x_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
828: G_PKG_NAME,
829: l_api_version,
830: p_api_version,
831: p_init_msg_list,

Line 1083: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);

1079: x_msg_count ,
1080: x_msg_data );
1081: END IF;
1082:
1083: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1084:
1085: EXCEPTION
1086: WHEN FND_API.G_EXC_ERROR THEN
1087: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS

Line 1087: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS

1083: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1084:
1085: EXCEPTION
1086: WHEN FND_API.G_EXC_ERROR THEN
1087: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1088: (
1089: l_api_name,
1090: G_PKG_NAME,
1091: 'FND_API.G_RET_STS_ERROR',

Line 1097: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

1093: x_msg_data,
1094: '_Pvt'
1095: );
1096: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1097: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1098: (
1099: l_api_name,
1100: G_PKG_NAME,
1101: 'FND_API.G_RET_STS_UNEXP_ERROR',

Line 1107: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

1103: x_msg_data,
1104: '_Pvt'
1105: );
1106: WHEN OTHERS THEN
1107: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1108: (
1109: l_api_name,
1110: G_PKG_NAME,
1111: 'OTHERS',

Line 1136: x_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,

1132: Begin
1133:
1134: --DBMS_Output.Put_Line('In Migrate to table');
1135:
1136: x_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
1137: G_PKG_NAME,
1138: l_api_version,
1139: p_api_version,
1140: p_init_msg_list,

Line 1195: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);

1191: := p_contract_rec_type.V_Coverage;
1192:
1193: --DBMS_Output.Put_Line('Before end activity');
1194:
1195: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1196:
1197: --DBMS_Output.Put_Line('After end activity');
1198:
1199: EXCEPTION

Line 1202: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS

1198:
1199: EXCEPTION
1200: WHEN FND_API.G_EXC_ERROR THEN
1201: --DBMS_Output.Put_Line('Expected Error');
1202: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1203: (
1204: l_api_name,
1205: G_PKG_NAME,
1206: 'FND_API.G_RET_STS_ERROR',

Line 1213: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

1209: '_Pvt'
1210: );
1211: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1212: --DBMS_Output.Put_Line('UnExpected Error');
1213: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1214: (
1215: l_api_name,
1216: G_PKG_NAME,
1217: 'FND_API.G_RET_STS_UNEXP_ERROR',

Line 1224: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

1220: '_Pvt'
1221: );
1222: WHEN OTHERS THEN
1223: --DBMS_Output.Put_Line('Others');
1224: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1225: (
1226: l_api_name,
1227: G_PKG_NAME,
1228: 'OTHERS',

Line 1283: x_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,

1279: Begin
1280:
1281: --DBMS_Output.Put_Line('In count and get');
1282:
1283: x_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
1284: G_PKG_NAME,
1285: l_api_version,
1286: p_api_version,
1287: p_init_msg_list,

Line 1345: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);

1341: G_Contracts_Tab_Type(p_rec_index).V_Coverage_Id;
1342: x_coverage :=
1343: G_Contracts_Tab_Type(p_rec_index).V_Coverage;
1344:
1345: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1346:
1347: EXCEPTION
1348: WHEN FND_API.G_EXC_ERROR THEN
1349: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS

Line 1349: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS

1345: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1346:
1347: EXCEPTION
1348: WHEN FND_API.G_EXC_ERROR THEN
1349: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1350: (
1351: l_api_name,
1352: G_PKG_NAME,
1353: 'FND_API.G_RET_STS_ERROR',

Line 1359: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

1355: x_msg_data,
1356: '_Pvt'
1357: );
1358: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1359: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1360: (
1361: l_api_name,
1362: G_PKG_NAME,
1363: 'FND_API.G_RET_STS_UNEXP_ERROR',

Line 1369: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

1365: x_msg_data,
1366: '_Pvt'
1367: );
1368: WHEN OTHERS THEN
1369: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1370: (
1371: l_api_name,
1372: G_PKG_NAME,
1373: 'OTHERS',

Line 1423: x_return_status := TAPI_DEV_KIT.START_ACTIVITY(

1419:
1420: l_api_name VARCHAR2(30) := G_PKG_NAME;
1421: l_api_version NUMBER := G_API_VERSION;
1422: BEGIN
1423: x_return_status := TAPI_DEV_KIT.START_ACTIVITY(
1424: l_api_name,
1425: G_PKG_NAME,
1426: l_api_version,
1427: p_api_version,

Line 1458: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);

1454: x_Service_End_Date := x_contract_rec_type.V_Service_End_Date;
1455: x_Coverage_Id := x_contract_rec_type.V_Coverage_Id;
1456: x_coverage := x_contract_rec_type.V_Coverage;
1457:
1458: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1459:
1460: EXCEPTION
1461: WHEN FND_API.G_EXC_ERROR THEN
1462: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS

Line 1462: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS

1458: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1459:
1460: EXCEPTION
1461: WHEN FND_API.G_EXC_ERROR THEN
1462: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1463: (
1464: l_api_name,
1465: G_PKG_NAME,
1466: 'FND_API.G_RET_STS_ERROR',

Line 1472: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

1468: x_msg_data,
1469: '_Pvt'
1470: );
1471: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1472: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1473: (
1474: l_api_name,
1475: G_PKG_NAME,
1476: 'FND_API.G_RET_STS_UNEXP_ERROR',

Line 1482: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

1478: x_msg_data,
1479: '_Pvt'
1480: );
1481: WHEN OTHERS THEN
1482: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1483: (
1484: l_api_name,
1485: G_PKG_NAME,
1486: 'OTHERS',