111: USER,
112: 1,
113: 'CZ_POPULATORS_PKG',
114: 11276,
115: fnd_msg_pub.GET(i,fnd_api.g_false),
116: mCOUNTER);
117: COMMIT;
118: END LOOP;
119: END IF;
193: ROLLBACK;
194: l_msg_index := 1;
195: WHILE l_msg_count > 0
196: LOOP
197: l_msg_data := fnd_msg_pub.get(l_msg_index,fnd_api.g_false);
198: LOG_REPORT('CZ_POPULATORS_PKG.lock_Model',l_msg_data);
199: l_msg_index := l_msg_index + 1;
200: l_msg_count := l_msg_count - 1;
201: END LOOP;
198: LOG_REPORT('CZ_POPULATORS_PKG.lock_Model',l_msg_data);
199: l_msg_index := l_msg_index + 1;
200: l_msg_count := l_msg_count - 1;
201: END LOOP;
202: FND_MSG_PUB.initialize;
203: RAISE FAILED_TO_LOCK_MODEL;
204: ELSE
205: COMMIT;
206: END IF;
453:
454: p_err := 0;
455:
456: IF UPPER(p_init_fnd_stack) IN('1','Y','YES') THEN
457: FND_MSG_PUB.initialize;
458: END IF;
459:
460: SELECT CZ_XFR_RUN_INFOS_S.NEXTVAL INTO mRUN_ID FROM dual;
461:
1016:
1017: p_err := 0;
1018:
1019: IF UPPER(p_init_fnd_stack) IN('1','Y','YES') THEN
1020: FND_MSG_PUB.initialize;
1021: END IF;
1022:
1023: SELECT CZ_XFR_RUN_INFOS_S.NEXTVAL INTO mRUN_ID FROM dual;
1024:
1378:
1379: p_err := 0;
1380:
1381: IF UPPER(p_init_fnd_stack) IN('1','Y','YES') THEN
1382: FND_MSG_PUB.initialize;
1383: END IF;
1384:
1385: SELECT CZ_XFR_RUN_INFOS_S.NEXTVAL INTO mRUN_ID FROM dual;
1386:
1524:
1525: p_err := 0;
1526:
1527: IF UPPER(p_init_fnd_stack) IN('1','Y','YES') THEN
1528: FND_MSG_PUB.initialize;
1529: END IF;
1530:
1531: SELECT CZ_XFR_RUN_INFOS_S.NEXTVAL INTO mRUN_ID FROM dual;
1532: