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.OKS_RULE_MIGRATE dependencies on DBMS_TRANSACTION

Line 20818: DBMS_TRANSACTION.SAVEPOINT('BEFORE_TRANSACTION');

20814: -- FND_FILE.PUT_LINE(FND_FILE.LOG ,'----------------------------------------------------------------------------------');
20815: -- FND_FILE.PUT_LINE(FND_FILE.LOG ,'-------------- Start of Sub request for Header Rule Data Reprocessing --------');
20816: -- FND_FILE.PUT_LINE(FND_FILE.LOG ,'----------------------------------------------------------------------------------');
20817:
20818: DBMS_TRANSACTION.SAVEPOINT('BEFORE_TRANSACTION');
20819: Begin
20820: If(p_us_yn) THEN
20821: OPEN l_hdr_rule_csr(p_id);
20822: FETCH l_hdr_rule_csr into

Line 21305: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');

21301: ------------------------------------------------------------------------------------------------
21302:
21303: if ( iEflag = 1) THEN
21304:
21305: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
21306: chr_id := l_chr_id;
21307: --1. Validation for ARL rule .
21308: BEGIN
21309: ACCT_RULE_ID := ACCT_RULE_ID_CHR;

Line 22820: DBMS_TRANSACTION.SAVEPOINT('BEFORE_TRANSACTION');

22816: FND_FILE.PUT_LINE(FND_FILE.LOG ,'----------------------------------------------------------------------------------');
22817: FND_FILE.PUT_LINE(FND_FILE.LOG ,'-------------- Start of Sub request for Line Rule Data Reprocessing --------');
22818: FND_FILE.PUT_LINE(FND_FILE.LOG ,'----------------------------------------------------------------------------------');
22819:
22820: DBMS_TRANSACTION.SAVEPOINT('BEFORE_TRANSACTION');
22821: Begin
22822: If (p_us_yn) then
22823: open l_line_rule_csr(p_id);
22824: fetch l_line_rule_csr into

Line 23549: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');

23545: --------------------------------------------------------------------------------------------------
23546: if (iEflag = 1) THEN
23547: --o(l_cle_id||' Going for validation ');
23548:
23549: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
23550: cle_id := l_cle_id;
23551: dnz_chr_id := l_dnz_chr_id;
23552:
23553: --1. Validation for DST rule .

Line 25027: DBMS_TRANSACTION.SAVEPOINT('BEFORE_TRANSACTION');

25023: FND_FILE.PUT_LINE(FND_FILE.LOG ,'----------------------------------------------------------------------------------');
25024: FND_FILE.PUT_LINE(FND_FILE.LOG ,'--------------Start of Sub request for Header History Rule Data Reprocessing--------');
25025: FND_FILE.PUT_LINE(FND_FILE.LOG ,'----------------------------------------------------------------------------------');
25026:
25027: DBMS_TRANSACTION.SAVEPOINT('BEFORE_TRANSACTION');
25028:
25029:
25030: if(p_us_yn) THEN
25031: OPEN l_hdr_rule_csr(p_id);

Line 25407: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');

25403: -- If data fails validation then set the Eflag to 1
25404:
25405: if( iEflag = 1) THEN
25406:
25407: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
25408:
25409: --1. Validation for ARL rule .
25410: BEGIN
25411: ACCT_RULE_ID := ACCT_RULE_ID_CHR;

Line 26400: DBMS_TRANSACTION.SAVEPOINT('BEFORE_TRANSACTION');

26396: LOCK_EXCEPTION EXCEPTION;
26397:
26398: BEGIN
26399:
26400: DBMS_TRANSACTION.SAVEPOINT('BEFORE_TRANSACTION');
26401:
26402: BEGIN
26403: open l_lock_line_csr(p_id);
26404: fetch l_lock_line_csr into l_lock_id;

Line 26456: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');

26452: Exception
26453: When LOCK_EXCEPTIOn then
26454: X_RETURN_STATUS := 'E';
26455: L_ERROR_MSG := SQLERRM;
26456: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
26457: Update oks_rule_reprocess
26458: set errormsg=L_ERROR_MSG
26459: where rowid=prow_id;
26460: FND_FILE.PUT_LINE(FND_FILE.LOG ,'DML Failed for LOCK OKSSYNHL '||p_id||'with Error Message '||L_ERROR_MSG);

Line 26464: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');

26460: FND_FILE.PUT_LINE(FND_FILE.LOG ,'DML Failed for LOCK OKSSYNHL '||p_id||'with Error Message '||L_ERROR_MSG);
26461: WHEN OTHERS THEN
26462: X_RETURN_STATUS := 'E';
26463: L_ERROR_MSG := SQLERRM;
26464: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
26465: Update oks_rule_reprocess
26466: set errormsg=L_ERROR_MSG
26467: where rowid=prow_id;
26468: FND_FILE.PUT_LINE(FND_FILE.LOG ,'DML Failed for LOCK OKSSYNHL '||p_id||'with Error Message '||L_ERROR_MSG);

Line 26528: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');

26524: Exception
26525: When others then
26526: X_RETURN_STATUS := 'E';
26527: L_ERROR_MSG := SQLERRM;
26528: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
26529: Update oks_rule_reprocess
26530: set errormsg=L_ERROR_MSG
26531: where rowid=prow_id;
26532: FND_FILE.PUT_LINE(FND_FILE.LOG ,'DML Failed for Reprocess of OKSLEVEL '||p_id||'with Error Message '||L_ERROR_MSG);

Line 27060: DBMS_TRANSACTION.SAVEPOINT('BEFORE_TRANSACTION');

27056: FND_FILE.PUT_LINE(FND_FILE.LOG ,'----------------------------------------------------------------------------------');
27057: FND_FILE.PUT_LINE(FND_FILE.LOG ,'--------------Start of Sub request for Line History Rule Data Reprocessing--------');
27058: FND_FILE.PUT_LINE(FND_FILE.LOG ,'----------------------------------------------------------------------------------');
27059:
27060: DBMS_TRANSACTION.SAVEPOINT('BEFORE_TRANSACTION');
27061:
27062:
27063: if(p_us_yn) THEN
27064: OPEN l_line_rule_csr(p_id);

Line 27558: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');

27554: -- If data fails validation then set the Eflag to 1
27555:
27556: if(iEflag = 1) THEN
27557:
27558: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
27559:
27560: -- Begin of code to validate data type .
27561: --1. Validation for DST rule .
27562: BEGIN

Line 29551: DBMS_TRANSACTION.SAVEPOINT('BEFORE_TRANSACTION');

29547: FND_FILE.PUT_LINE(FND_FILE.LOG ,'----------------------------------------------------------------------------------');
29548: FND_FILE.PUT_LINE(FND_FILE.LOG ,'--------------Start of Sub request for Header Rule Data Synchronisation--------');
29549: FND_FILE.PUT_LINE(FND_FILE.LOG ,'----------------------------------------------------------------------------------');
29550:
29551: DBMS_TRANSACTION.SAVEPOINT('BEFORE_TRANSACTION');
29552:
29553: BEGIN
29554: OPEN L_LOCK_HDR_CSR( p_chr_id);
29555: FETCH L_LOCK_HDR_CSR into L_LOCK_ID;

Line 30103: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');

30099: Exception
30100: When others then
30101: X_RETURN_STATUS := 'E';
30102: L_ERROR_MSG := SQLERRM;
30103: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
30104: FND_FILE.PUT_LINE(FND_FILE.LOG ,'DML Failed for LOCK OKSSYNHL in header synchronize code '||p_chr_id||'with Error Message '||L_ERROR_MSG);
30105: RAISE ;
30106: END ;
30107: End If;

Line 30113: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');

30109:
30110:
30111: If(Eflag=1) Then
30112:
30113: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
30114:
30115: -- Begin of code to validate data type .
30116: -- If data fails validation then set the Eflag to 1
30117:

Line 31624: DBMS_TRANSACTION.SAVEPOINT('BEFORE_TRANSACTION');

31620:
31621: L_DNZ_CHR_ID := DNZ_CHR_ID;
31622:
31623:
31624: DBMS_TRANSACTION.SAVEPOINT('BEFORE_TRANSACTION');
31625:
31626: if(p_us_yn) then
31627: OPEN l_line_rule_csr(p_rgp_id);
31628:

Line 32253: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');

32249: End If; -- l_check_var is not null
32250:
32251: if(Eflag=1) THEN
32252:
32253: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
32254:
32255: ------------------------------------------------------------------------------------
32256: -- Begin of code to validate data type .
32257: -- If data fails validation then set the Eflag to 1

Line 33681: DBMS_TRANSACTION.SAVEPOINT('BEFORE_TRANSACTION');

33677: RAISE LOCK_EXCEPTION;
33678: END;
33679: L_DNZ_CHR_ID := DNZ_CHR_ID;
33680:
33681: DBMS_TRANSACTION.SAVEPOINT('BEFORE_TRANSACTION');
33682:
33683: if(p_us_yn) then
33684: OPEN l_line_rule_csr(p_rgp_id);
33685: FETCH l_line_rule_csr into

Line 34293: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');

34289: End If;
34290: End If; -- l_check_var is not null
34291: if(Eflag=1) THEN
34292:
34293: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
34294: ------------------------------------------------------------------------------------
34295: -- Begin of code to validate data type .
34296: -- If data fails validation then set the Eflag to 1
34297:

Line 35736: DBMS_TRANSACTION.SAVEPOINT('BEFORE_TRANSACTION');

35732: FND_FILE.PUT_LINE(FND_FILE.LOG ,'----------------------------------------------------------------------------------');
35733: FND_FILE.PUT_LINE(FND_FILE.LOG ,'--------------Start of Sub request for Header History Rule Data Synchronization--------');
35734: FND_FILE.PUT_LINE(FND_FILE.LOG ,'----------------------------------------------------------------------------------');
35735:
35736: DBMS_TRANSACTION.SAVEPOINT('BEFORE_TRANSACTION');
35737:
35738: if(p_us_yn) then
35739:
35740: OPEN l_hdr_rule_csr(p_rgp_id);

Line 36228: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');

36224:
36225:
36226: If(Eflag=1) Then
36227:
36228: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
36229: ------------------------------------------------------------------------------------
36230: -- Begin of code to validate data type .
36231: -- If data fails validation then set the Eflag to 1
36232:

Line 37203: DBMS_TRANSACTION.SAVEPOINT('BEFORE_TRANSACTION');

37199: FND_FILE.PUT_LINE(FND_FILE.LOG ,'----------------------------------------------------------------------------------');
37200: FND_FILE.PUT_LINE(FND_FILE.LOG ,'--------------Start of Sub request for LINE RULE SLL ----------------------------');
37201: FND_FILE.PUT_LINE(FND_FILE.LOG ,'----------------------------------------------------------------------------------');
37202:
37203: DBMS_TRANSACTION.SAVEPOINT('BEFORE_TRANSACTION');
37204:
37205: DELETE FROM OKS_STREAM_LEVELS_B
37206: WHERE cle_id = P_CLE_ID;
37207:

Line 37365: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');

37361:
37362: EXCEPTION
37363: WHEN OTHERS THEN
37364: FND_FILE.PUT_LINE(FND_FILE.LOG ,'DML Failed for'||p_rgp_id||'with Error Message '||SQLERRM);
37365: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
37366: X_RETURN_STATUS := 'E';
37367: L_ERROR_MSG := SQLERRM;
37368:
37369:

Line 37389: DBMS_TRANSACTION.SAVEPOINT('BEFORE_TRANSACTION');

37385: FND_FILE.PUT_LINE(FND_FILE.LOG ,'----------------------------------------------------------------------------------');
37386: FND_FILE.PUT_LINE(FND_FILE.LOG ,'--------------Start of Sub request for HDR RULE SLL ----------------------------');
37387: FND_FILE.PUT_LINE(FND_FILE.LOG ,'----------------------------------------------------------------------------------');
37388:
37389: DBMS_TRANSACTION.SAVEPOINT('BEFORE_TRANSACTION');
37390:
37391: DELETE FROM OKS_STREAM_LEVELS_B
37392: WHERE chr_id = P_CHR_ID;
37393: insert into oks_stream_levels_b(

Line 37428: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');

37424:
37425: EXCEPTION
37426: WHEN OTHERS THEN
37427: FND_FILE.PUT_LINE(FND_FILE.LOG ,'DML Failed for SLL HDR Sync '||p_rgp_id||'with Error Message '||SQLERRM);
37428: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
37429: X_RETURN_STATUS := 'E';
37430: L_ERROR_MSG := SQLERRM;
37431:
37432: END SYNCHRONIZE_RULE_SLLH;

Line 37525: DBMS_TRANSACTION.SAVEPOINT('BEFORE_TRANSACTION');

37521: FND_FILE.PUT_LINE(FND_FILE.LOG ,'----------------------------------------------------------------------------------');
37522: FND_FILE.PUT_LINE(FND_FILE.LOG ,'--------------Start of Sub request for LINE RULE OFS ----------------------------');
37523: FND_FILE.PUT_LINE(FND_FILE.LOG ,'----------------------------------------------------------------------------------');
37524:
37525: DBMS_TRANSACTION.SAVEPOINT('BEFORE_TRANSACTION');
37526:
37527:
37528: IF L_MAJOR_VERSION IS NULL THEN
37529:

Line 37692: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');

37688: X_RETURN_STATUS := 'S';
37689:
37690: EXCEPTION
37691: WHEN OTHERS THEN
37692: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
37693: X_RETURN_STATUS := 'E';
37694: L_ERROR_MSG := SQLERRM;
37695: FND_FILE.PUT_LINE(FND_FILE.LOG ,'DML Failed for'||p_rgp_id||'with Error Message '||L_ERROR_MSG);
37696:

Line 37734: DBMS_TRANSACTION.SAVEPOINT('BEFORE_TRANSACTION');

37730: FND_FILE.PUT_LINE(FND_FILE.LOG ,'----------------------------------------------------------------------------------');
37731: FND_FILE.PUT_LINE(FND_FILE.LOG ,'--------------Start of Sub request for LINE RULE CVR ----------------------------');
37732: FND_FILE.PUT_LINE(FND_FILE.LOG ,'----------------------------------------------------------------------------------');
37733:
37734: DBMS_TRANSACTION.SAVEPOINT('BEFORE_TRANSACTION');
37735:
37736: IF L_MAJOR_VERSION IS NULL THEN
37737:
37738: BEGIN

Line 37926: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');

37922: X_RETURN_STATUS := 'S';
37923:
37924: EXCEPTION
37925: WHEN OTHERS THEN
37926: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
37927: X_RETURN_STATUS := 'E';
37928: L_ERROR_MSG := SQLERRM;
37929: FND_FILE.PUT_LINE(FND_FILE.LOG ,'DML Failed for'||p_rgp_id||'with Error Message '||L_ERROR_MSG);
37930:

Line 37981: DBMS_TRANSACTION.SAVEPOINT('BEFORE_TRANSACTION');

37977: FND_FILE.PUT_LINE(FND_FILE.LOG ,'----------------------------------------------------------------------------------');
37978: FND_FILE.PUT_LINE(FND_FILE.LOG ,'--------------Start of Sub request for LINE RULE RCN/RSN--------------------------');
37979: FND_FILE.PUT_LINE(FND_FILE.LOG ,'----------------------------------------------------------------------------------');
37980:
37981: DBMS_TRANSACTION.SAVEPOINT('BEFORE_TRANSACTION');
37982:
37983: DELETE OKS_ACTION_TIMES
37984: WHERE CLE_ID = L_CLE_ID
37985: AND DNZ_CHR_ID = L_DNZ_CHR_ID;

Line 38232: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');

38228: X_RETURN_STATUS := 'S';
38229:
38230: EXCEPTION
38231: WHEN OTHERS THEN
38232: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
38233: X_RETURN_STATUS := 'E';
38234: L_ERROR_MSG := SQLERRM;
38235: FND_FILE.PUT_LINE(FND_FILE.LOG ,'DML Failed for'||p_rgp_id||'with Error Message '||L_ERROR_MSG);
38236:

Line 38297: DBMS_TRANSACTION.SAVEPOINT('BEFORE_TRANSACTION');

38293: FND_FILE.PUT_LINE(FND_FILE.LOG ,'----------------------------------------------------------------------------------');
38294: FND_FILE.PUT_LINE(FND_FILE.LOG ,'--------------Start of Sub request for LINE RULE RCN/RSN--------------------------');
38295: FND_FILE.PUT_LINE(FND_FILE.LOG ,'----------------------------------------------------------------------------------');
38296:
38297: DBMS_TRANSACTION.SAVEPOINT('BEFORE_TRANSACTION');
38298:
38299: DELETE OKS_ACTION_TIMES_H
38300: WHERE CLE_ID = L_CLE_ID
38301: AND DNZ_CHR_ID = L_DNZ_CHR_ID

Line 38568: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');

38564: X_RETURN_STATUS := 'S';
38565:
38566: EXCEPTION
38567: WHEN OTHERS THEN
38568: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
38569: X_RETURN_STATUS := 'E';
38570: L_ERROR_MSG := SQLERRM;
38571: FND_FILE.PUT_LINE(FND_FILE.LOG ,'DML Failed for'||p_rgp_id||'with Error Message '||L_ERROR_MSG);
38572:

Line 38588: DBMS_TRANSACTION.SAVEPOINT('BEFORE_TRANSACTION');

38584: L_ERROR_MSG VARCHAR2(2000);
38585:
38586: BEGIN
38587:
38588: DBMS_TRANSACTION.SAVEPOINT('BEFORE_TRANSACTION');
38589:
38590: DELETE FROM OKS_PM_STREAM_LEVELS
38591: WHERE CLE_ID = L_CLE_ID
38592: AND DNZ_CHR_ID = L_DNZ_CHR_ID;

Line 38720: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');

38716: X_RETURN_STATUS := 'S';
38717:
38718: EXCEPTION
38719: WHEN OTHERS THEN
38720: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_TRANSACTION');
38721: X_RETURN_STATUS := 'E';
38722: L_ERROR_MSG := SQLERRM;
38723: FND_FILE.PUT_LINE(FND_FILE.LOG ,'DML Failed for'||p_rgp_id||'with Error Message '||L_ERROR_MSG);
38724: