DBA Data[Home] [Help]

APPS.XLA_CMP_LOCK_PAD_PKG dependencies on XLA_EXCEPTIONS_PKG

Line 75: WHEN xla_exceptions_pkg.application_exception THEN

71: fnd_log.string(p_level, p_module, p_msg);
72: END IF;
73:
74: EXCEPTION
75: WHEN xla_exceptions_pkg.application_exception THEN
76: RAISE;
77: WHEN OTHERS THEN
78: xla_exceptions_pkg.raise_message
79: (p_location => 'xla_cmp_lock_pad_pkg.trace');

Line 78: xla_exceptions_pkg.raise_message

74: EXCEPTION
75: WHEN xla_exceptions_pkg.application_exception THEN
76: RAISE;
77: WHEN OTHERS THEN
78: xla_exceptions_pkg.raise_message
79: (p_location => 'xla_cmp_lock_pad_pkg.trace');
80: END trace;
81:
82:

Line 249: WHEN xla_exceptions_pkg.application_exception THEN

245:
246: END IF;
247: --
248: EXCEPTION
249: WHEN xla_exceptions_pkg.application_exception THEN
250: IF Description_cur%ISOPEN THEN
251: CLOSE Description_cur;
252: END IF;
253: IF Description_prio_cur%ISOPEN THEN

Line 260: WHEN xla_exceptions_pkg.resource_busy THEN

256: IF Description_dtl_cur%ISOPEN THEN
257: CLOSE Description_dtl_cur;
258: END IF;
259: RAISE;
260: WHEN xla_exceptions_pkg.resource_busy THEN
261: IF Description_cur%ISOPEN THEN
262: CLOSE Description_cur;
263: END IF;
264: IF Description_prio_cur%ISOPEN THEN

Line 277: xla_exceptions_pkg.raise_message

273: (p_msg => 'ERROR: XLA_CMP_COMPONENTS_LOCKED'
274: ,p_level => C_LEVEL_EXCEPTION
275: ,p_module => l_log_module);
276: END IF;
277: xla_exceptions_pkg.raise_message
278: ( 'XLA'
279: ,'XLA_CMP_COMPONENTS_LOCKED'
280: ,'PAD_NAME'
281: , g_product_rule_name

Line 290: xla_exceptions_pkg.raise_message

286: IF Description_cur%ISOPEN THEN
287: CLOSE Description_cur;
288: END IF;
289: -- SLA message to define
290: xla_exceptions_pkg.raise_message
291: (p_location => 'xla_cmp_lock_pad_pkg.LockRowLineDesc');
292: END LockRowLineDesc;
293:
294:

Line 413: WHEN xla_exceptions_pkg.application_exception THEN

409:
410: END IF;
411: --
412: EXCEPTION
413: WHEN xla_exceptions_pkg.application_exception THEN
414: IF Description_cur%ISOPEN THEN
415: CLOSE Description_cur;
416: END IF;
417: IF Description_prio_cur%ISOPEN THEN

Line 424: WHEN xla_exceptions_pkg.resource_busy THEN

420: IF Description_dtl_cur%ISOPEN THEN
421: CLOSE Description_dtl_cur;
422: END IF;
423: RAISE;
424: WHEN xla_exceptions_pkg.resource_busy THEN
425: IF Description_cur%ISOPEN THEN
426: CLOSE Description_cur;
427: END IF;
428: IF Description_prio_cur%ISOPEN THEN

Line 441: xla_exceptions_pkg.raise_message

437: (p_msg => 'ERROR: XLA_CMP_COMPONENTS_LOCKED'
438: ,p_level => C_LEVEL_EXCEPTION
439: ,p_module => l_log_module);
440: END IF;
441: xla_exceptions_pkg.raise_message
442: ( 'XLA'
443: ,'XLA_CMP_COMPONENTS_LOCKED'
444: ,'PAD_NAME'
445: , g_product_rule_name

Line 454: xla_exceptions_pkg.raise_message

450: IF Description_cur%ISOPEN THEN
451: CLOSE Description_cur;
452: END IF;
453: -- SLA message to define
454: xla_exceptions_pkg.raise_message
455: (p_location => 'xla_cmp_lock_pad_pkg.LockRowHdrDesc');
456: END LockRowHdrDesc;
457: --
458: --

Line 528: WHEN xla_exceptions_pkg.application_exception THEN

524:
525: END IF;
526: --
527: EXCEPTION
528: WHEN xla_exceptions_pkg.application_exception THEN
529: IF SourceAssignment_cur%ISOPEN THEN
530: CLOSE SourceAssignment_cur;
531: END IF;
532: RAISE;

Line 533: WHEN xla_exceptions_pkg.resource_busy THEN

529: IF SourceAssignment_cur%ISOPEN THEN
530: CLOSE SourceAssignment_cur;
531: END IF;
532: RAISE;
533: WHEN xla_exceptions_pkg.resource_busy THEN
534: IF SourceAssignment_cur%ISOPEN THEN
535: CLOSE SourceAssignment_cur;
536: END IF;
537: -- SLA message

Line 544: xla_exceptions_pkg.raise_message

540: (p_msg => 'ERROR: XLA_CMP_COMPONENTS_LOCKED'
541: ,p_level => C_LEVEL_EXCEPTION
542: ,p_module => l_log_module);
543: END IF;
544: xla_exceptions_pkg.raise_message
545: ( 'XLA'
546: ,'XLA_CMP_COMPONENTS_LOCKED'
547: ,'PAD_NAME'
548: , g_product_rule_name

Line 558: xla_exceptions_pkg.raise_message

554: IF SourceAssignment_cur%ISOPEN THEN
555: CLOSE SourceAssignment_cur;
556: END IF;
557: -- SLA message to define
558: xla_exceptions_pkg.raise_message
559: (p_location => 'xla_cmp_lock_pad_pkg.LockRowSourceAssignment');
560: END LockRowSourceAssignment;
561: --
562: --

Line 629: WHEN xla_exceptions_pkg.application_exception THEN

625:
626: END IF;
627: --
628: EXCEPTION
629: WHEN xla_exceptions_pkg.application_exception THEN
630: IF ExtractObject_cur%ISOPEN THEN
631: CLOSE ExtractObject_cur;
632: END IF;
633: RAISE;

Line 634: WHEN xla_exceptions_pkg.resource_busy THEN

630: IF ExtractObject_cur%ISOPEN THEN
631: CLOSE ExtractObject_cur;
632: END IF;
633: RAISE;
634: WHEN xla_exceptions_pkg.resource_busy THEN
635: IF ExtractObject_cur%ISOPEN THEN
636: CLOSE ExtractObject_cur;
637: END IF;
638: -- SLA message

Line 645: xla_exceptions_pkg.raise_message

641: (p_msg => 'ERROR: XLA_CMP_COMPONENTS_LOCKED'
642: ,p_level => C_LEVEL_EXCEPTION
643: ,p_module => l_log_module);
644: END IF;
645: xla_exceptions_pkg.raise_message
646: ( 'XLA'
647: ,'XLA_CMP_COMPONENTS_LOCKED'
648: ,'PAD_NAME'
649: , g_product_rule_name

Line 659: xla_exceptions_pkg.raise_message

655: IF ExtractObject_cur%ISOPEN THEN
656: CLOSE ExtractObject_cur;
657: END IF;
658: -- SLA message to define
659: xla_exceptions_pkg.raise_message
660: (p_location => 'xla_cmp_lock_pad_pkg.LockRowExtractObject');
661: END LockRowExtractObject;
662: --
663: --+==========================================================================+

Line 733: WHEN xla_exceptions_pkg.application_exception THEN

729:
730: END IF;
731: --
732: EXCEPTION
733: WHEN xla_exceptions_pkg.application_exception THEN
734: IF EventType_cur%ISOPEN THEN
735: CLOSE EventType_cur;
736: END IF;
737: RAISE;

Line 738: WHEN xla_exceptions_pkg.resource_busy THEN

734: IF EventType_cur%ISOPEN THEN
735: CLOSE EventType_cur;
736: END IF;
737: RAISE;
738: WHEN xla_exceptions_pkg.resource_busy THEN
739: IF EventType_cur%ISOPEN THEN
740: CLOSE EventType_cur;
741: END IF;
742: -- SLA message

Line 749: xla_exceptions_pkg.raise_message

745: (p_msg => 'ERROR: XLA_CMP_COMPONENTS_LOCKED'
746: ,p_level => C_LEVEL_EXCEPTION
747: ,p_module => l_log_module);
748: END IF;
749: xla_exceptions_pkg.raise_message
750: ( 'XLA'
751: ,'XLA_CMP_COMPONENTS_LOCKED'
752: ,'PAD_NAME'
753: , g_product_rule_name

Line 763: xla_exceptions_pkg.raise_message

759: IF EventType_cur%ISOPEN THEN
760: CLOSE EventType_cur;
761: END IF;
762: -- SLA message to define
763: xla_exceptions_pkg.raise_message
764: (p_location => 'xla_cmp_lock_pad_pkg.LockRowEventType');
765: END LockRowEventType;
766: --
767: --+==========================================================================+

Line 837: WHEN xla_exceptions_pkg.application_exception THEN

833:
834: END IF;
835: --
836: EXCEPTION
837: WHEN xla_exceptions_pkg.application_exception THEN
838: IF EventClassGrp_cur%ISOPEN THEN
839: CLOSE EventClassGrp_cur;
840: END IF;
841: RAISE;

Line 842: WHEN xla_exceptions_pkg.resource_busy THEN

838: IF EventClassGrp_cur%ISOPEN THEN
839: CLOSE EventClassGrp_cur;
840: END IF;
841: RAISE;
842: WHEN xla_exceptions_pkg.resource_busy THEN
843: IF EventClassGrp_cur%ISOPEN THEN
844: CLOSE EventClassGrp_cur;
845: END IF;
846: -- SLA message

Line 853: xla_exceptions_pkg.raise_message

849: (p_msg => 'ERROR: XLA_CMP_COMPONENTS_LOCKED'
850: ,p_level => C_LEVEL_EXCEPTION
851: ,p_module => l_log_module);
852: END IF;
853: xla_exceptions_pkg.raise_message
854: ( 'XLA'
855: ,'XLA_CMP_COMPONENTS_LOCKED'
856: ,'PAD_NAME'
857: , g_product_rule_name

Line 867: xla_exceptions_pkg.raise_message

863: IF EventClassGrp_cur%ISOPEN THEN
864: CLOSE EventClassGrp_cur;
865: END IF;
866: -- SLA message to define
867: xla_exceptions_pkg.raise_message
868: (p_location => 'xla_cmp_lock_pad_pkg.LockRowEventClassGrp');
869: END LockRowEventClassGrp;
870: --
871: --+==========================================================================+

Line 939: WHEN xla_exceptions_pkg.application_exception THEN

935:
936: END IF;
937: --
938: EXCEPTION
939: WHEN xla_exceptions_pkg.application_exception THEN
940: IF EventClass_cur%ISOPEN THEN
941: CLOSE EventClass_cur;
942: END IF;
943: RAISE;

Line 944: WHEN xla_exceptions_pkg.resource_busy THEN

940: IF EventClass_cur%ISOPEN THEN
941: CLOSE EventClass_cur;
942: END IF;
943: RAISE;
944: WHEN xla_exceptions_pkg.resource_busy THEN
945: IF EventClass_cur%ISOPEN THEN
946: CLOSE EventClass_cur;
947: END IF;
948: -- SLA message

Line 955: xla_exceptions_pkg.raise_message

951: (p_msg => 'ERROR: XLA_CMP_COMPONENTS_LOCKED'
952: ,p_level => C_LEVEL_EXCEPTION
953: ,p_module => l_log_module);
954: END IF;
955: xla_exceptions_pkg.raise_message
956: ( 'XLA'
957: ,'XLA_CMP_COMPONENTS_LOCKED'
958: ,'PAD_NAME'
959: , g_product_rule_name

Line 969: xla_exceptions_pkg.raise_message

965: IF EventClass_cur%ISOPEN THEN
966: CLOSE EventClass_cur;
967: END IF;
968: -- SLA message to define
969: xla_exceptions_pkg.raise_message
970: (p_location => 'xla_cmp_lock_pad_pkg.LockRowEventClass');
971: END LockRowEventClass;
972: --
973: --+==========================================================================+

Line 1056: WHEN xla_exceptions_pkg.application_exception THEN

1052:
1053: END IF;
1054: --
1055: EXCEPTION
1056: WHEN xla_exceptions_pkg.application_exception THEN
1057: IF ADR_cur%ISOPEN THEN
1058: CLOSE ADR_cur;
1059: END IF;
1060: RAISE;

Line 1061: WHEN xla_exceptions_pkg.resource_busy THEN

1057: IF ADR_cur%ISOPEN THEN
1058: CLOSE ADR_cur;
1059: END IF;
1060: RAISE;
1061: WHEN xla_exceptions_pkg.resource_busy THEN
1062: IF ADR_cur%ISOPEN THEN
1063: CLOSE ADR_cur;
1064: END IF;
1065: -- SLA message

Line 1066: xla_exceptions_pkg.raise_message

1062: IF ADR_cur%ISOPEN THEN
1063: CLOSE ADR_cur;
1064: END IF;
1065: -- SLA message
1066: xla_exceptions_pkg.raise_message
1067: ( 'XLA'
1068: ,'XLA_CMP_COMPONENTS_LOCKED'
1069: ,'PAD_NAME'
1070: , g_product_rule_name

Line 1079: xla_exceptions_pkg.raise_message

1075: IF ADR_cur%ISOPEN THEN
1076: CLOSE ADR_cur;
1077: END IF;
1078: -- SLA message to define
1079: xla_exceptions_pkg.raise_message
1080: (p_location => 'xla_cmp_lock_pad_pkg.LockRowADR');
1081: END LockRowADR;
1082: --
1083: --

Line 1201: WHEN xla_exceptions_pkg.application_exception THEN

1197:
1198: END IF;
1199: --
1200: EXCEPTION
1201: WHEN xla_exceptions_pkg.application_exception THEN
1202: IF AcctgLines_cur%ISOPEN THEN
1203: CLOSE AcctgLines_cur;
1204: END IF;
1205: RAISE;

Line 1206: WHEN xla_exceptions_pkg.resource_busy THEN

1202: IF AcctgLines_cur%ISOPEN THEN
1203: CLOSE AcctgLines_cur;
1204: END IF;
1205: RAISE;
1206: WHEN xla_exceptions_pkg.resource_busy THEN
1207: IF AcctgLines_cur%ISOPEN THEN
1208: CLOSE AcctgLines_cur;
1209: END IF;
1210: -- SLA message to define

Line 1211: xla_exceptions_pkg.raise_message

1207: IF AcctgLines_cur%ISOPEN THEN
1208: CLOSE AcctgLines_cur;
1209: END IF;
1210: -- SLA message to define
1211: xla_exceptions_pkg.raise_message
1212: ( 'XLA'
1213: ,'XLA_CMP_COMPONENTS_LOCKED'
1214: ,'PAD_NAME'
1215: , g_product_rule_name

Line 1224: xla_exceptions_pkg.raise_message

1220: IF AcctgLines_cur%ISOPEN THEN
1221: CLOSE AcctgLines_cur;
1222: END IF;
1223: -- SLA message to define
1224: xla_exceptions_pkg.raise_message
1225: (p_location => 'xla_cmp_lock_pad_pkg.LockRowAcctgLines');
1226: END LockRowAcctgLines;
1227: --
1228: --+==========================================================================+

Line 1336: WHEN xla_exceptions_pkg.application_exception THEN

1332:
1333: END IF;
1334: --
1335: EXCEPTION
1336: WHEN xla_exceptions_pkg.application_exception THEN
1337: IF Headers_cur%ISOPEN THEN
1338: CLOSE Headers_cur;
1339: END IF;
1340: RAISE;

Line 1341: WHEN xla_exceptions_pkg.resource_busy THEN

1337: IF Headers_cur%ISOPEN THEN
1338: CLOSE Headers_cur;
1339: END IF;
1340: RAISE;
1341: WHEN xla_exceptions_pkg.resource_busy THEN
1342: IF Headers_cur%ISOPEN THEN
1343: CLOSE Headers_cur;
1344: END IF;
1345: -- SLA message to define

Line 1346: xla_exceptions_pkg.raise_message

1342: IF Headers_cur%ISOPEN THEN
1343: CLOSE Headers_cur;
1344: END IF;
1345: -- SLA message to define
1346: xla_exceptions_pkg.raise_message
1347: ( 'XLA'
1348: ,'XLA_CMP_COMPONENTS_LOCKED'
1349: ,'PAD_NAME'
1350: , g_product_rule_name

Line 1359: xla_exceptions_pkg.raise_message

1355: IF Headers_cur%ISOPEN THEN
1356: CLOSE Headers_cur;
1357: END IF;
1358: -- SLA message to define
1359: xla_exceptions_pkg.raise_message
1360: (p_location => 'xla_cmp_lock_pad_pkg.LockRowHeaders');
1361: END LockRowHeaders;
1362: --
1363: --+==========================================================================+

Line 1455: WHEN xla_exceptions_pkg.application_exception THEN

1451:
1452: END IF;
1453: --
1454: EXCEPTION
1455: WHEN xla_exceptions_pkg.application_exception THEN
1456: IF pad_cur%ISOPEN THEN
1457: CLOSE pad_cur;
1458: END IF;
1459: RAISE;

Line 1460: WHEN xla_exceptions_pkg.resource_busy THEN

1456: IF pad_cur%ISOPEN THEN
1457: CLOSE pad_cur;
1458: END IF;
1459: RAISE;
1460: WHEN xla_exceptions_pkg.resource_busy THEN
1461: IF pad_cur%ISOPEN THEN
1462: CLOSE pad_cur;
1463: END IF;
1464: -- SLA message

Line 1465: xla_exceptions_pkg.raise_message

1461: IF pad_cur%ISOPEN THEN
1462: CLOSE pad_cur;
1463: END IF;
1464: -- SLA message
1465: xla_exceptions_pkg.raise_message
1466: ( 'XLA'
1467: ,'XLA_CMP_COMPONENTS_LOCKED'
1468: ,'PAD_NAME'
1469: , g_product_rule_name

Line 1478: xla_exceptions_pkg.raise_message

1474: IF pad_cur%ISOPEN THEN
1475: CLOSE pad_cur;
1476: END IF;
1477: -- SLA message to define
1478: xla_exceptions_pkg.raise_message
1479: (p_location => 'xla_cmp_lock_pad_pkg.LockRowPAD');
1480: END LockRowPAD;
1481: --
1482: --+==========================================================================+

Line 1559: WHEN xla_exceptions_pkg.application_exception THEN

1555: --
1556: RETURN TRUE;
1557: --
1558: EXCEPTION
1559: WHEN xla_exceptions_pkg.application_exception THEN
1560: --
1561: ROLLBACK TO LockPADRows;
1562: --
1563: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN

Line 1583: xla_exceptions_pkg.raise_message

1579: WHEN OTHERS THEN
1580: --
1581: ROLLBACK TO LockPADRows;
1582: --
1583: xla_exceptions_pkg.raise_message
1584: (p_location => 'xla_cmp_lock_pad_pkg.LockPAD');
1585: END LockPAD;
1586: --
1587: --=============================================================================