APPS.OKS_MASSCHANGE_PVT dependencies on DBMS_TRANSACTION

Line 7784: DBMS_TRANSACTION.SAVEPOINT('BEFORE_MASSCHANGE_START');

7780:
7781:
7782: LOG_MESSAGES('starts processing ....');
7783:
7784: DBMS_TRANSACTION.SAVEPOINT('BEFORE_MASSCHANGE_START');
7785:
7786: LOG_MESSAGES('Before get_criteria_cur');
7787:
7788: OPEN get_criteria_cur;

Line 7914: DBMS_TRANSACTION.SAVEPOINT('BEFORE_MASSCHANGE');

7910:
7911: FND_MSG_PUB.Initialize;
7912: l_status := 'SUCCESS';
7913: l_message := null; --'Successfully completed';
7914: DBMS_TRANSACTION.SAVEPOINT('BEFORE_MASSCHANGE');
7915:
7916: --UPDATE_LINE_STATUS(p_ole_id => l_eligible_contracts_tbl(i).ole_id);
7917: --Update the attribute
7918: LOG_MESSAGES('Processing Contract contract number :'||l_eligible_contracts_tbl(i).contract_number);

Line 12040: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_MASSCHANGE');

12036: x_olev_rec => l_olev_rec_out);
12037:
12038: --commit;
12039: ELSIF p_process_type = 'PREVIEW' then
12040: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_MASSCHANGE');
12041:
12042: l_olev_rec_in.id := l_eligible_contracts_tbl(i).ole_id;
12043: l_olev_rec_in.process_flag := 'A';
12044:

Line 12056: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_MASSCHANGE');

12052: x_olev_rec => l_olev_rec_out);
12053: --commit;
12054: END IF;
12055: ELSE
12056: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_MASSCHANGE');
12057: l_olev_rec_in.id := l_eligible_contracts_tbl(i).ole_id;
12058: l_olev_rec_in.process_flag := 'E';
12059:
12060: OKC_OPER_INST_PUB.Update_Operation_Line (

Line 12092: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_MASSCHANGE');

12088: WHEN G_EXCEPTION_HALT_VALIDATION THEN
12089: l_error_cnt := l_error_cnt + 1;
12090: l_status := FND_MESSAGE.get_string('OKS','OKS_MSCHG_ERROR');
12091: -- l_status := 'ERROR';
12092: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_MASSCHANGE');
12093: LOG_MESSAGES('G_EXCEPTION_HALT_VALIDATION in inner LOOP');
12094: --Update operation lines with ERROR (revisit)
12095: l_olev_rec_in.id := l_eligible_contracts_tbl(i).ole_id;
12096: l_olev_rec_in.process_flag := 'E';

Line 12119: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_MASSCHANGE');

12115: rpad(substr(nvl(l_old_value,' '),1,25),25,' ') ;
12116: l_outfiles_fail(l_outfile_fail_id).String3 := pad(l_status,22)||' '||l_message ;
12117:
12118: WHEN l_notelligible_exception THEN
12119: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_MASSCHANGE');
12120: LOG_MESSAGES('l_notelligible_exception in inner LOOP');
12121:
12122: l_olev_rec_in.id := l_eligible_contracts_tbl(i).ole_id;
12123: l_olev_rec_in.process_flag := NULL ;

Line 12153: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_MASSCHANGE');

12149:
12150:
12151: WHEN OTHERS THEN
12152:
12153: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_MASSCHANGE');
12154: LOG_MESSAGES('For oie_id:'||p_oie_id||', Others EXCEPTION:'||SQLERRM);
12155: l_error_cnt := l_error_cnt + 1;
12156: l_status := FND_MESSAGE.get_string('OKS','OKS_MSCHG_ERROR');
12157: -- l_status := 'ERROR';

Line 12431: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_MASSCHANGE_START');

12427: ||' *********',45,'L') );
12428:
12429: EXCEPTION
12430: WHEN OTHERS THEN
12431: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_MASSCHANGE_START');
12432: LOG_MESSAGES('For oie_id:'||p_oie_id||', Others EXCEPTION in outer:'||SQLERRM);
12433: l_oiev_rec_in.id := p_oie_id;
12434: l_oiev_rec_in.status_code := 'ERROR';
12435: OKC_OPER_INST_PUB.Update_Operation_Instance (