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.M4R_7B1_WSM_IN dependencies on FND_MESSAGE

Line 193: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_NO_JOB');

189: cln_debug_pub.Add('Error is ' || g_error_code || ' : ' || g_errmsg, 5);
190: cln_debug_pub.Add('x_return_code : ' || x_return_code, 5);
191: END IF;
192:
193: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_NO_JOB');
194: FND_MESSAGE.SET_TOKEN('JOB_NAME',p_job_name);
195:
196: x_int_err :=FND_MESSAGE.GET;
197:

Line 194: FND_MESSAGE.SET_TOKEN('JOB_NAME',p_job_name);

190: cln_debug_pub.Add('x_return_code : ' || x_return_code, 5);
191: END IF;
192:
193: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_NO_JOB');
194: FND_MESSAGE.SET_TOKEN('JOB_NAME',p_job_name);
195:
196: x_int_err :=FND_MESSAGE.GET;
197:
198: x_err_msg := g_exception_tracking_msg || ':' ||g_error_code || ' : ' || g_errmsg;

Line 196: x_int_err :=FND_MESSAGE.GET;

192:
193: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_NO_JOB');
194: FND_MESSAGE.SET_TOKEN('JOB_NAME',p_job_name);
195:
196: x_int_err :=FND_MESSAGE.GET;
197:
198: x_err_msg := g_exception_tracking_msg || ':' ||g_error_code || ' : ' || g_errmsg;
199:
200: WHEN OTHERS THEN

Line 214: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_UNEXPECTED_ERR');

210: END IF;
211:
212: x_err_msg := g_exception_tracking_msg || ':' ||g_error_code || ' : ' || g_errmsg;
213:
214: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_UNEXPECTED_ERR');
215: FND_MESSAGE.SET_TOKEN('HDR_ID', p_hdr_id);
216:
217: x_int_err :=FND_MESSAGE.GET;
218:

Line 215: FND_MESSAGE.SET_TOKEN('HDR_ID', p_hdr_id);

211:
212: x_err_msg := g_exception_tracking_msg || ':' ||g_error_code || ' : ' || g_errmsg;
213:
214: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_UNEXPECTED_ERR');
215: FND_MESSAGE.SET_TOKEN('HDR_ID', p_hdr_id);
216:
217: x_int_err :=FND_MESSAGE.GET;
218:
219: END GET_JOB_DETAILS;

Line 217: x_int_err :=FND_MESSAGE.GET;

213:
214: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_UNEXPECTED_ERR');
215: FND_MESSAGE.SET_TOKEN('HDR_ID', p_hdr_id);
216:
217: x_int_err :=FND_MESSAGE.GET;
218:
219: END GET_JOB_DETAILS;
220:
221:

Line 344: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_NO_OP_SEQ');

340: END IF;
341:
342: x_err_msg := g_exception_tracking_msg || ':' ||g_error_code || ' : ' || g_errmsg;
343:
344: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_NO_OP_SEQ');
345: x_int_err :=FND_MESSAGE.GET;
346:
347: WHEN OTHERS THEN
348: g_error_code := SQLCODE;

Line 345: x_int_err :=FND_MESSAGE.GET;

341:
342: x_err_msg := g_exception_tracking_msg || ':' ||g_error_code || ' : ' || g_errmsg;
343:
344: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_NO_OP_SEQ');
345: x_int_err :=FND_MESSAGE.GET;
346:
347: WHEN OTHERS THEN
348: g_error_code := SQLCODE;
349: g_errmsg := SQLERRM;

Line 361: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_UNEXPECTED_ERR');

357: END IF;
358:
359: x_err_msg := g_exception_tracking_msg || ':' ||g_error_code || ' : ' || g_errmsg;
360:
361: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_UNEXPECTED_ERR');
362: FND_MESSAGE.SET_TOKEN('HDR_ID', p_hdr_id);
363:
364: x_int_err :=FND_MESSAGE.GET;
365:

Line 362: FND_MESSAGE.SET_TOKEN('HDR_ID', p_hdr_id);

358:
359: x_err_msg := g_exception_tracking_msg || ':' ||g_error_code || ' : ' || g_errmsg;
360:
361: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_UNEXPECTED_ERR');
362: FND_MESSAGE.SET_TOKEN('HDR_ID', p_hdr_id);
363:
364: x_int_err :=FND_MESSAGE.GET;
365:
366: END GET_DEPT_AND_OP_ID;

Line 364: x_int_err :=FND_MESSAGE.GET;

360:
361: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_UNEXPECTED_ERR');
362: FND_MESSAGE.SET_TOKEN('HDR_ID', p_hdr_id);
363:
364: x_int_err :=FND_MESSAGE.GET;
365:
366: END GET_DEPT_AND_OP_ID;
367:
368:

Line 439: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_NO_ITEM');

435: END IF;
436:
437: x_err_msg := g_exception_tracking_msg || ':' ||g_error_code || ' : ' || g_errmsg;
438:
439: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_NO_ITEM');
440:
441: x_int_err :=FND_MESSAGE.GET;
442:
443: WHEN OTHERS THEN

Line 441: x_int_err :=FND_MESSAGE.GET;

437: x_err_msg := g_exception_tracking_msg || ':' ||g_error_code || ' : ' || g_errmsg;
438:
439: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_NO_ITEM');
440:
441: x_int_err :=FND_MESSAGE.GET;
442:
443: WHEN OTHERS THEN
444: g_error_code := SQLCODE;
445: g_errmsg := SQLERRM;

Line 457: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_UNEXPECTED_ERR');

453: END IF;
454:
455: x_err_msg := g_exception_tracking_msg || ':' ||g_error_code || ' : ' || g_errmsg;
456:
457: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_UNEXPECTED_ERR');
458: FND_MESSAGE.SET_TOKEN('HDR_ID', p_hdr_id);
459:
460: x_int_err :=FND_MESSAGE.GET;
461:

Line 458: FND_MESSAGE.SET_TOKEN('HDR_ID', p_hdr_id);

454:
455: x_err_msg := g_exception_tracking_msg || ':' ||g_error_code || ' : ' || g_errmsg;
456:
457: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_UNEXPECTED_ERR');
458: FND_MESSAGE.SET_TOKEN('HDR_ID', p_hdr_id);
459:
460: x_int_err :=FND_MESSAGE.GET;
461:
462: END GET_INV_ITEM_DETAILS;

Line 460: x_int_err :=FND_MESSAGE.GET;

456:
457: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_UNEXPECTED_ERR');
458: FND_MESSAGE.SET_TOKEN('HDR_ID', p_hdr_id);
459:
460: x_int_err :=FND_MESSAGE.GET;
461:
462: END GET_INV_ITEM_DETAILS;
463:
464:

Line 1413: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_VALID_FAIL');

1409: UPDATE_STATUS_FLAG(p_hdr_rec.msg_id,p_hdr_rec.hdr_id,'I',l_custom_valid_err_msg,NULL);
1410:
1411: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'NOTIF_CODE','7B1_NOTIF2');
1412:
1413: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_VALID_FAIL');
1414: FND_MESSAGE.SET_TOKEN('GRP_ID',l_group_id);
1415:
1416: l_interface_err :=FND_MESSAGE.GET;
1417:

Line 1414: FND_MESSAGE.SET_TOKEN('GRP_ID',l_group_id);

1410:
1411: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'NOTIF_CODE','7B1_NOTIF2');
1412:
1413: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_VALID_FAIL');
1414: FND_MESSAGE.SET_TOKEN('GRP_ID',l_group_id);
1415:
1416: l_interface_err :=FND_MESSAGE.GET;
1417:
1418: ADD_MSG_COLL_HIST ( l_interface_err ,

Line 1416: l_interface_err :=FND_MESSAGE.GET;

1412:
1413: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_VALID_FAIL');
1414: FND_MESSAGE.SET_TOKEN('GRP_ID',l_group_id);
1415:
1416: l_interface_err :=FND_MESSAGE.GET;
1417:
1418: ADD_MSG_COLL_HIST ( l_interface_err ,
1419: p_hdr_rec.transaction_type,
1420: p_hdr_rec.lot_number,

Line 1512: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_TXN_FAILED');

1508: --IF ((l_err_msg1 IS NOT NULL) OR (l_interface_status <> 4) OR (l_err_flag <> 'N')) THEN -- bsaratna
1509: IF ((l_err_msg1 IS NOT NULL) OR (l_interface_status <> 4) OR (l_err_flag = 'Y')) THEN -- 'errors'
1510: UPDATE_STATUS_FLAG(p_hdr_rec.msg_id,p_hdr_rec.hdr_id,'E',l_err_msg1 || l_err_msg2,l_group_id);
1511:
1512: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_TXN_FAILED');
1513: FND_MESSAGE.SET_TOKEN('GRP_ID',l_group_id);
1514:
1515: l_interface_err :=FND_MESSAGE.GET;
1516:

Line 1513: FND_MESSAGE.SET_TOKEN('GRP_ID',l_group_id);

1509: IF ((l_err_msg1 IS NOT NULL) OR (l_interface_status <> 4) OR (l_err_flag = 'Y')) THEN -- 'errors'
1510: UPDATE_STATUS_FLAG(p_hdr_rec.msg_id,p_hdr_rec.hdr_id,'E',l_err_msg1 || l_err_msg2,l_group_id);
1511:
1512: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_TXN_FAILED');
1513: FND_MESSAGE.SET_TOKEN('GRP_ID',l_group_id);
1514:
1515: l_interface_err :=FND_MESSAGE.GET;
1516:
1517: ADD_MSG_COLL_HIST ( l_err_msg1 || l_err_msg2,

Line 1515: l_interface_err :=FND_MESSAGE.GET;

1511:
1512: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_TXN_FAILED');
1513: FND_MESSAGE.SET_TOKEN('GRP_ID',l_group_id);
1514:
1515: l_interface_err :=FND_MESSAGE.GET;
1516:
1517: ADD_MSG_COLL_HIST ( l_err_msg1 || l_err_msg2,
1518: p_hdr_rec.transaction_type,
1519: p_hdr_rec.lot_number,

Line 1582: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_UNEXPECTED_ERR');

1578: UPDATE_STATUS_FLAG(p_hdr_rec.msg_id,p_hdr_rec.hdr_id,'I',l_err_msg,NULL);
1579:
1580: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'NOTIF_CODE','7B1_NOTIF2');
1581:
1582: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_UNEXPECTED_ERR');
1583: FND_MESSAGE.SET_TOKEN('HDR_ID', p_hdr_rec.hdr_id);
1584:
1585: l_interface_err := FND_MESSAGE.GET;
1586:

Line 1583: FND_MESSAGE.SET_TOKEN('HDR_ID', p_hdr_rec.hdr_id);

1579:
1580: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'NOTIF_CODE','7B1_NOTIF2');
1581:
1582: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_UNEXPECTED_ERR');
1583: FND_MESSAGE.SET_TOKEN('HDR_ID', p_hdr_rec.hdr_id);
1584:
1585: l_interface_err := FND_MESSAGE.GET;
1586:
1587: ADD_MSG_COLL_HIST ( l_interface_err ,

Line 1585: l_interface_err := FND_MESSAGE.GET;

1581:
1582: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_UNEXPECTED_ERR');
1583: FND_MESSAGE.SET_TOKEN('HDR_ID', p_hdr_rec.hdr_id);
1584:
1585: l_interface_err := FND_MESSAGE.GET;
1586:
1587: ADD_MSG_COLL_HIST ( l_interface_err ,
1588: p_hdr_rec.transaction_type,
1589: p_hdr_rec.lot_number,

Line 1865: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_VALID_FAIL');

1861: UPDATE_STATUS_FLAG(p_hdr_rec.msg_id,p_hdr_rec.hdr_id,'I',l_custom_valid_err_msg,l_group_id);
1862:
1863: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'NOTIF_CODE','7B1_NOTIF2');
1864:
1865: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_VALID_FAIL');
1866: FND_MESSAGE.SET_TOKEN('GRP_ID',l_group_id);
1867:
1868: l_interface_err :=FND_MESSAGE.GET;
1869:

Line 1866: FND_MESSAGE.SET_TOKEN('GRP_ID',l_group_id);

1862:
1863: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'NOTIF_CODE','7B1_NOTIF2');
1864:
1865: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_VALID_FAIL');
1866: FND_MESSAGE.SET_TOKEN('GRP_ID',l_group_id);
1867:
1868: l_interface_err :=FND_MESSAGE.GET;
1869:
1870: ADD_MSG_COLL_HIST ( l_interface_err ,

Line 1868: l_interface_err :=FND_MESSAGE.GET;

1864:
1865: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_VALID_FAIL');
1866: FND_MESSAGE.SET_TOKEN('GRP_ID',l_group_id);
1867:
1868: l_interface_err :=FND_MESSAGE.GET;
1869:
1870: ADD_MSG_COLL_HIST ( l_interface_err ,
1871: p_hdr_rec.transaction_type,
1872: p_hdr_rec.lot_number,

Line 1942: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_UNEXPECTED_ERR');

1938: END IF;
1939:
1940: UPDATE_STATUS_FLAG(p_hdr_rec.msg_id,p_hdr_rec.hdr_id,'I',l_err_msg,l_header_id);
1941:
1942: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_UNEXPECTED_ERR');
1943: FND_MESSAGE.SET_TOKEN('HDR_ID', l_header_id);
1944:
1945: l_interface_err := FND_MESSAGE.GET;
1946:

Line 1943: FND_MESSAGE.SET_TOKEN('HDR_ID', l_header_id);

1939:
1940: UPDATE_STATUS_FLAG(p_hdr_rec.msg_id,p_hdr_rec.hdr_id,'I',l_err_msg,l_header_id);
1941:
1942: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_UNEXPECTED_ERR');
1943: FND_MESSAGE.SET_TOKEN('HDR_ID', l_header_id);
1944:
1945: l_interface_err := FND_MESSAGE.GET;
1946:
1947: ADD_MSG_COLL_HIST ( l_interface_err ,

Line 1945: l_interface_err := FND_MESSAGE.GET;

1941:
1942: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_UNEXPECTED_ERR');
1943: FND_MESSAGE.SET_TOKEN('HDR_ID', l_header_id);
1944:
1945: l_interface_err := FND_MESSAGE.GET;
1946:
1947: ADD_MSG_COLL_HIST ( l_interface_err ,
1948: p_hdr_rec.transaction_type,
1949: p_hdr_rec.lot_number,

Line 2124: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_OTH_TXN_FAIL');

2120: IF (g_debug_level <= 1) THEN
2121: cln_debug_pub.Add(g_exception_tracking_msg, 1);
2122: END IF;
2123:
2124: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_OTH_TXN_FAIL');
2125: l_err_msg :=FND_MESSAGE.GET;
2126:
2127: UPDATE M4R_WSM_DWIP_HDR_STAGING
2128: SET status_flag ='E',

Line 2125: l_err_msg :=FND_MESSAGE.GET;

2121: cln_debug_pub.Add(g_exception_tracking_msg, 1);
2122: END IF;
2123:
2124: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_OTH_TXN_FAIL');
2125: l_err_msg :=FND_MESSAGE.GET;
2126:
2127: UPDATE M4R_WSM_DWIP_HDR_STAGING
2128: SET status_flag ='E',
2129: error_message = l_err_msg

Line 2171: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_OTH_TXN_FAIL');

2167: IF (g_debug_level <= 1) THEN
2168: cln_debug_pub.Add(g_exception_tracking_msg, 1);
2169: END IF;
2170:
2171: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_OTH_TXN_FAIL');
2172: l_interface_err1 :=FND_MESSAGE.GET;
2173:
2174: UPDATE M4R_WSM_DWIP_HDR_STAGING
2175: SET status_flag ='E',

Line 2172: l_interface_err1 :=FND_MESSAGE.GET;

2168: cln_debug_pub.Add(g_exception_tracking_msg, 1);
2169: END IF;
2170:
2171: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_OTH_TXN_FAIL');
2172: l_interface_err1 :=FND_MESSAGE.GET;
2173:
2174: UPDATE M4R_WSM_DWIP_HDR_STAGING
2175: SET status_flag ='E',
2176: error_message = l_interface_err1

Line 2265: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_NO_JOB');

2261: cln_debug_pub.Add('g_exception_tracking_msg : ' || g_exception_tracking_msg, 5);
2262: cln_debug_pub.Add('Error is ' || g_error_code || ' : ' || g_errmsg, 5);
2263: END IF;
2264:
2265: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_NO_JOB');
2266: FND_MESSAGE.SET_TOKEN('JOB_NAME',p_hdr_rec.prev_lot_number);
2267:
2268: l_interface_err :=FND_MESSAGE.GET;
2269:

Line 2266: FND_MESSAGE.SET_TOKEN('JOB_NAME',p_hdr_rec.prev_lot_number);

2262: cln_debug_pub.Add('Error is ' || g_error_code || ' : ' || g_errmsg, 5);
2263: END IF;
2264:
2265: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_NO_JOB');
2266: FND_MESSAGE.SET_TOKEN('JOB_NAME',p_hdr_rec.prev_lot_number);
2267:
2268: l_interface_err :=FND_MESSAGE.GET;
2269:
2270: l_err_msg := g_exception_tracking_msg || ':' ||g_error_code || ' : ' || g_errmsg;

Line 2268: l_interface_err :=FND_MESSAGE.GET;

2264:
2265: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_NO_JOB');
2266: FND_MESSAGE.SET_TOKEN('JOB_NAME',p_hdr_rec.prev_lot_number);
2267:
2268: l_interface_err :=FND_MESSAGE.GET;
2269:
2270: l_err_msg := g_exception_tracking_msg || ':' ||g_error_code || ' : ' || g_errmsg;
2271: RAISE return_code_false;
2272: END;

Line 2323: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_OTH_TXN_FAIL');

2319: IF (g_debug_level <= 1) THEN
2320: cln_debug_pub.Add(g_exception_tracking_msg, 1);
2321: END IF;
2322:
2323: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_OTH_TXN_FAIL');
2324: l_err_msg :=FND_MESSAGE.GET;
2325:
2326: UPDATE M4R_WSM_DWIP_HDR_STAGING
2327: SET status_flag ='E',

Line 2324: l_err_msg :=FND_MESSAGE.GET;

2320: cln_debug_pub.Add(g_exception_tracking_msg, 1);
2321: END IF;
2322:
2323: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_OTH_TXN_FAIL');
2324: l_err_msg :=FND_MESSAGE.GET;
2325:
2326: UPDATE M4R_WSM_DWIP_HDR_STAGING
2327: SET status_flag ='E',
2328: error_message = l_err_msg

Line 2359: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_OTH_TXN_FAIL');

2355: IF (g_debug_level <= 1) THEN
2356: cln_debug_pub.Add(g_exception_tracking_msg, 1);
2357: END IF;
2358:
2359: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_OTH_TXN_FAIL');
2360: l_interface_err1 :=FND_MESSAGE.GET;
2361:
2362: UPDATE M4R_WSM_DWIP_HDR_STAGING
2363: SET status_flag ='E',

Line 2360: l_interface_err1 :=FND_MESSAGE.GET;

2356: cln_debug_pub.Add(g_exception_tracking_msg, 1);
2357: END IF;
2358:
2359: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_OTH_TXN_FAIL');
2360: l_interface_err1 :=FND_MESSAGE.GET;
2361:
2362: UPDATE M4R_WSM_DWIP_HDR_STAGING
2363: SET status_flag ='E',
2364: error_message = l_interface_err1

Line 2494: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_NO_JOB');

2490: cln_debug_pub.Add('g_exception_tracking_msg : ' || g_exception_tracking_msg, 5);
2491: cln_debug_pub.Add('Error is ' || g_error_code || ' : ' || g_errmsg, 5);
2492: END IF;
2493:
2494: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_NO_JOB');
2495: FND_MESSAGE.SET_TOKEN('JOB_NAME',l_job_name);
2496:
2497: l_interface_err :=FND_MESSAGE.GET;
2498:

Line 2495: FND_MESSAGE.SET_TOKEN('JOB_NAME',l_job_name);

2491: cln_debug_pub.Add('Error is ' || g_error_code || ' : ' || g_errmsg, 5);
2492: END IF;
2493:
2494: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_NO_JOB');
2495: FND_MESSAGE.SET_TOKEN('JOB_NAME',l_job_name);
2496:
2497: l_interface_err :=FND_MESSAGE.GET;
2498:
2499: l_err_msg := g_exception_tracking_msg || ':' ||g_error_code || ' : ' || g_errmsg;

Line 2497: l_interface_err :=FND_MESSAGE.GET;

2493:
2494: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_NO_JOB');
2495: FND_MESSAGE.SET_TOKEN('JOB_NAME',l_job_name);
2496:
2497: l_interface_err :=FND_MESSAGE.GET;
2498:
2499: l_err_msg := g_exception_tracking_msg || ':' ||g_error_code || ' : ' || g_errmsg;
2500: RAISE return_code_false;
2501: END;

Line 2683: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_VALID_FAIL');

2679: AND status_flag ='T';
2680:
2681: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'NOTIF_CODE','7B1_NOTIF1');
2682:
2683: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_VALID_FAIL');
2684: FND_MESSAGE.SET_TOKEN('GRP_ID',l_group_id);
2685:
2686: l_interface_err :=FND_MESSAGE.GET;
2687:

Line 2684: FND_MESSAGE.SET_TOKEN('GRP_ID',l_group_id);

2680:
2681: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'NOTIF_CODE','7B1_NOTIF1');
2682:
2683: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_VALID_FAIL');
2684: FND_MESSAGE.SET_TOKEN('GRP_ID',l_group_id);
2685:
2686: l_interface_err :=FND_MESSAGE.GET;
2687:
2688: ADD_MSG_COLL_HIST ( l_interface_err ,

Line 2686: l_interface_err :=FND_MESSAGE.GET;

2682:
2683: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_VALID_FAIL');
2684: FND_MESSAGE.SET_TOKEN('GRP_ID',l_group_id);
2685:
2686: l_interface_err :=FND_MESSAGE.GET;
2687:
2688: ADD_MSG_COLL_HIST ( l_interface_err ,
2689: p_hdr_rec.transaction_type,
2690: p_hdr_rec.lot_number,

Line 2754: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_TXN_FAILED');

2750: END LOOP;
2751:
2752: IF l_errloop_cnt > 0 THEN
2753:
2754: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_TXN_FAILED');
2755: FND_MESSAGE.SET_TOKEN('GRP_ID',l_group_id);
2756: l_interface_err := FND_MESSAGE.GET || l_interface_err;
2757:
2758: IF (g_debug_level <= 1) THEN

Line 2755: FND_MESSAGE.SET_TOKEN('GRP_ID',l_group_id);

2751:
2752: IF l_errloop_cnt > 0 THEN
2753:
2754: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_TXN_FAILED');
2755: FND_MESSAGE.SET_TOKEN('GRP_ID',l_group_id);
2756: l_interface_err := FND_MESSAGE.GET || l_interface_err;
2757:
2758: IF (g_debug_level <= 1) THEN
2759: cln_debug_pub.Add('l_interface_err : ' || l_interface_err, 1);

Line 2756: l_interface_err := FND_MESSAGE.GET || l_interface_err;

2752: IF l_errloop_cnt > 0 THEN
2753:
2754: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_TXN_FAILED');
2755: FND_MESSAGE.SET_TOKEN('GRP_ID',l_group_id);
2756: l_interface_err := FND_MESSAGE.GET || l_interface_err;
2757:
2758: IF (g_debug_level <= 1) THEN
2759: cln_debug_pub.Add('l_interface_err : ' || l_interface_err, 1);
2760: END IF;

Line 2826: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_TXN_FAILED');

2822: AND status_flag = 'R';
2823:
2824: IF l_interface_err IS NULL THEN
2825:
2826: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_TXN_FAILED');
2827: FND_MESSAGE.SET_TOKEN('GRP_ID',l_group_id);
2828: l_interface_err := FND_MESSAGE.GET;
2829:
2830: END IF;

Line 2827: FND_MESSAGE.SET_TOKEN('GRP_ID',l_group_id);

2823:
2824: IF l_interface_err IS NULL THEN
2825:
2826: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_TXN_FAILED');
2827: FND_MESSAGE.SET_TOKEN('GRP_ID',l_group_id);
2828: l_interface_err := FND_MESSAGE.GET;
2829:
2830: END IF;
2831:

Line 2828: l_interface_err := FND_MESSAGE.GET;

2824: IF l_interface_err IS NULL THEN
2825:
2826: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_TXN_FAILED');
2827: FND_MESSAGE.SET_TOKEN('GRP_ID',l_group_id);
2828: l_interface_err := FND_MESSAGE.GET;
2829:
2830: END IF;
2831:
2832: ADD_MSG_COLL_HIST ( l_interface_err ,

Line 2893: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_CORR_REC_FAILED');

2889: x_resultout := 'FAILED';
2890:
2891: WHEN CORR_REC_FAILED THEN
2892:
2893: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_CORR_REC_FAILED');
2894:
2895: l_interface_err := FND_MESSAGE.GET;
2896:
2897: l_err_msg := g_exception_tracking_msg || ':' || l_interface_err;

Line 2895: l_interface_err := FND_MESSAGE.GET;

2891: WHEN CORR_REC_FAILED THEN
2892:
2893: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_CORR_REC_FAILED');
2894:
2895: l_interface_err := FND_MESSAGE.GET;
2896:
2897: l_err_msg := g_exception_tracking_msg || ':' || l_interface_err;
2898:
2899: IF (g_debug_level <= 5) THEN

Line 2929: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_UNEXPECTED_ERR');

2925: END IF;
2926:
2927: UPDATE_STATUS_FLAG(p_hdr_rec.msg_id,p_hdr_rec.hdr_id,'I',l_err_msg,l_group_id);
2928:
2929: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_UNEXPECTED_ERR');
2930: FND_MESSAGE.SET_TOKEN('HDR_ID', p_hdr_rec.hdr_id);
2931:
2932: l_interface_err := FND_MESSAGE.GET;
2933:

Line 2930: FND_MESSAGE.SET_TOKEN('HDR_ID', p_hdr_rec.hdr_id);

2926:
2927: UPDATE_STATUS_FLAG(p_hdr_rec.msg_id,p_hdr_rec.hdr_id,'I',l_err_msg,l_group_id);
2928:
2929: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_UNEXPECTED_ERR');
2930: FND_MESSAGE.SET_TOKEN('HDR_ID', p_hdr_rec.hdr_id);
2931:
2932: l_interface_err := FND_MESSAGE.GET;
2933:
2934: ADD_MSG_COLL_HIST ( l_interface_err ,

Line 2932: l_interface_err := FND_MESSAGE.GET;

2928:
2929: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_UNEXPECTED_ERR');
2930: FND_MESSAGE.SET_TOKEN('HDR_ID', p_hdr_rec.hdr_id);
2931:
2932: l_interface_err := FND_MESSAGE.GET;
2933:
2934: ADD_MSG_COLL_HIST ( l_interface_err ,
2935: p_hdr_rec.transaction_type,
2936: p_hdr_rec.lot_number,

Line 3259: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_OTH_TXN_FAIL');

3255:
3256: IF l_retcode = 'F' THEN
3257: ROLLBACK TO BEFORE_INSERT;
3258:
3259: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_OTH_TXN_FAIL');
3260: l_interface_err1 :=FND_MESSAGE.GET;
3261:
3262: UPDATE M4R_WSM_DWIP_HDR_STAGING
3263: SET status_flag ='E',

Line 3260: l_interface_err1 :=FND_MESSAGE.GET;

3256: IF l_retcode = 'F' THEN
3257: ROLLBACK TO BEFORE_INSERT;
3258:
3259: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_OTH_TXN_FAIL');
3260: l_interface_err1 :=FND_MESSAGE.GET;
3261:
3262: UPDATE M4R_WSM_DWIP_HDR_STAGING
3263: SET status_flag ='E',
3264: error_message = l_interface_err1,

Line 3319: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_OTH_TXN_FAIL');

3315: IF (g_debug_level <= 1) THEN
3316: cln_debug_pub.Add(g_exception_tracking_msg, 1);
3317: END IF;
3318:
3319: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_OTH_TXN_FAIL');
3320: l_interface_err :=FND_MESSAGE.GET;
3321:
3322: UPDATE M4R_WSM_DWIP_HDR_STAGING
3323: SET status_flag ='E',

Line 3320: l_interface_err :=FND_MESSAGE.GET;

3316: cln_debug_pub.Add(g_exception_tracking_msg, 1);
3317: END IF;
3318:
3319: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_OTH_TXN_FAIL');
3320: l_interface_err :=FND_MESSAGE.GET;
3321:
3322: UPDATE M4R_WSM_DWIP_HDR_STAGING
3323: SET status_flag ='E',
3324: error_message = l_interface_err

Line 3361: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_OTH_TXN_FAIL');

3357:
3358: IF l_retcode = 'F' THEN
3359: ROLLBACK TO BEFORE_INSERT;
3360:
3361: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_OTH_TXN_FAIL');
3362: l_interface_err1 :=FND_MESSAGE.GET;
3363:
3364: UPDATE M4R_WSM_DWIP_HDR_STAGING
3365: SET status_flag ='E',

Line 3362: l_interface_err1 :=FND_MESSAGE.GET;

3358: IF l_retcode = 'F' THEN
3359: ROLLBACK TO BEFORE_INSERT;
3360:
3361: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_OTH_TXN_FAIL');
3362: l_interface_err1 :=FND_MESSAGE.GET;
3363:
3364: UPDATE M4R_WSM_DWIP_HDR_STAGING
3365: SET status_flag ='E',
3366: error_message = l_interface_err1

Line 3425: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_OTH_TXN_FAIL');

3421:
3422: IF l_retcode = 'F' THEN
3423: ROLLBACK TO BEFORE_INSERT;
3424:
3425: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_OTH_TXN_FAIL');
3426: l_interface_err1 :=FND_MESSAGE.GET;
3427:
3428: UPDATE M4R_WSM_DWIP_HDR_STAGING
3429: SET status_flag ='E',

Line 3426: l_interface_err1 :=FND_MESSAGE.GET;

3422: IF l_retcode = 'F' THEN
3423: ROLLBACK TO BEFORE_INSERT;
3424:
3425: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_OTH_TXN_FAIL');
3426: l_interface_err1 :=FND_MESSAGE.GET;
3427:
3428: UPDATE M4R_WSM_DWIP_HDR_STAGING
3429: SET status_flag ='E',
3430: error_message = l_interface_err1

Line 3481: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_OTH_TXN_FAIL');

3477: IF (g_debug_level <= 1) THEN
3478: cln_debug_pub.Add(g_exception_tracking_msg, 1);
3479: END IF;
3480:
3481: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_OTH_TXN_FAIL');
3482: l_interface_err :=FND_MESSAGE.GET;
3483:
3484: UPDATE M4R_WSM_DWIP_HDR_STAGING
3485: SET status_flag ='E',

Line 3482: l_interface_err :=FND_MESSAGE.GET;

3478: cln_debug_pub.Add(g_exception_tracking_msg, 1);
3479: END IF;
3480:
3481: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_OTH_TXN_FAIL');
3482: l_interface_err :=FND_MESSAGE.GET;
3483:
3484: UPDATE M4R_WSM_DWIP_HDR_STAGING
3485: SET status_flag ='E',
3486: error_message = l_interface_err

Line 3526: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_OTH_TXN_FAIL');

3522:
3523: IF l_retcode = 'F' THEN
3524: ROLLBACK TO BEFORE_INSERT;
3525:
3526: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_OTH_TXN_FAIL');
3527: l_interface_err1 :=FND_MESSAGE.GET;
3528:
3529: UPDATE M4R_WSM_DWIP_HDR_STAGING
3530: SET status_flag ='E',

Line 3527: l_interface_err1 :=FND_MESSAGE.GET;

3523: IF l_retcode = 'F' THEN
3524: ROLLBACK TO BEFORE_INSERT;
3525:
3526: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_OTH_TXN_FAIL');
3527: l_interface_err1 :=FND_MESSAGE.GET;
3528:
3529: UPDATE M4R_WSM_DWIP_HDR_STAGING
3530: SET status_flag ='E',
3531: error_message = l_interface_err1

Line 3818: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_VALID_FAIL');

3814: UPDATE_STATUS_FLAG(p_hdr_rec.msg_id,p_hdr_rec.hdr_id,'I',l_custom_valid_err_msg,l_parent_id);
3815:
3816: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'NOTIF_CODE','7B1_NOTIF2');
3817:
3818: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_VALID_FAIL');
3819: FND_MESSAGE.SET_TOKEN('GRP_ID',l_trx_hdr_id);
3820:
3821: l_interface_err :=FND_MESSAGE.GET;
3822:

Line 3819: FND_MESSAGE.SET_TOKEN('GRP_ID',l_trx_hdr_id);

3815:
3816: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'NOTIF_CODE','7B1_NOTIF2');
3817:
3818: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_VALID_FAIL');
3819: FND_MESSAGE.SET_TOKEN('GRP_ID',l_trx_hdr_id);
3820:
3821: l_interface_err :=FND_MESSAGE.GET;
3822:
3823: ADD_MSG_COLL_HIST ( l_interface_err ,

Line 3821: l_interface_err :=FND_MESSAGE.GET;

3817:
3818: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_VALID_FAIL');
3819: FND_MESSAGE.SET_TOKEN('GRP_ID',l_trx_hdr_id);
3820:
3821: l_interface_err :=FND_MESSAGE.GET;
3822:
3823: ADD_MSG_COLL_HIST ( l_interface_err ,
3824: p_hdr_rec.transaction_type,
3825: p_hdr_rec.lot_number,

Line 3887: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_TXN_FAILED');

3883: AND status_flag ='R';
3884:
3885: IF l_err_code IS NULL THEN
3886:
3887: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_TXN_FAILED');
3888: FND_MESSAGE.SET_TOKEN('GRP_ID',l_trx_hdr_id);
3889: l_err_msg := FND_MESSAGE.GET;
3890:
3891: END IF;

Line 3888: FND_MESSAGE.SET_TOKEN('GRP_ID',l_trx_hdr_id);

3884:
3885: IF l_err_code IS NULL THEN
3886:
3887: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_TXN_FAILED');
3888: FND_MESSAGE.SET_TOKEN('GRP_ID',l_trx_hdr_id);
3889: l_err_msg := FND_MESSAGE.GET;
3890:
3891: END IF;
3892:

Line 3889: l_err_msg := FND_MESSAGE.GET;

3885: IF l_err_code IS NULL THEN
3886:
3887: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_TXN_FAILED');
3888: FND_MESSAGE.SET_TOKEN('GRP_ID',l_trx_hdr_id);
3889: l_err_msg := FND_MESSAGE.GET;
3890:
3891: END IF;
3892:
3893: ADD_MSG_COLL_HIST ( l_err_msg ,

Line 3933: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_TXN_FAILED');

3929: WHERE msg_id = p_hdr_rec.msg_id
3930: AND lot_number = p_hdr_rec.lot_number
3931: AND status_flag ='R';
3932:
3933: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_TXN_FAILED');
3934: FND_MESSAGE.SET_TOKEN('GRP_ID',l_trx_hdr_id);
3935: l_err_msg := FND_MESSAGE.GET;
3936:
3937: ADD_MSG_COLL_HIST ( l_err_msg ,

Line 3934: FND_MESSAGE.SET_TOKEN('GRP_ID',l_trx_hdr_id);

3930: AND lot_number = p_hdr_rec.lot_number
3931: AND status_flag ='R';
3932:
3933: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_TXN_FAILED');
3934: FND_MESSAGE.SET_TOKEN('GRP_ID',l_trx_hdr_id);
3935: l_err_msg := FND_MESSAGE.GET;
3936:
3937: ADD_MSG_COLL_HIST ( l_err_msg ,
3938: p_hdr_rec.transaction_type,

Line 3935: l_err_msg := FND_MESSAGE.GET;

3931: AND status_flag ='R';
3932:
3933: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_TXN_FAILED');
3934: FND_MESSAGE.SET_TOKEN('GRP_ID',l_trx_hdr_id);
3935: l_err_msg := FND_MESSAGE.GET;
3936:
3937: ADD_MSG_COLL_HIST ( l_err_msg ,
3938: p_hdr_rec.transaction_type,
3939: p_hdr_rec.lot_number,

Line 3955: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_TXN_FAILED');

3951: x_resultout := 'FAILED';
3952:
3953: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'NOTIF_CODE','7B1_NOTIF2');
3954:
3955: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_TXN_FAILED');
3956: FND_MESSAGE.SET_TOKEN('GRP_ID',l_trx_hdr_id);
3957: l_err_msg := FND_MESSAGE.GET;
3958:
3959: ADD_MSG_COLL_HIST ( l_err_msg ,

Line 3956: FND_MESSAGE.SET_TOKEN('GRP_ID',l_trx_hdr_id);

3952:
3953: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'NOTIF_CODE','7B1_NOTIF2');
3954:
3955: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_TXN_FAILED');
3956: FND_MESSAGE.SET_TOKEN('GRP_ID',l_trx_hdr_id);
3957: l_err_msg := FND_MESSAGE.GET;
3958:
3959: ADD_MSG_COLL_HIST ( l_err_msg ,
3960: p_hdr_rec.transaction_type,

Line 3957: l_err_msg := FND_MESSAGE.GET;

3953: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'NOTIF_CODE','7B1_NOTIF2');
3954:
3955: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_TXN_FAILED');
3956: FND_MESSAGE.SET_TOKEN('GRP_ID',l_trx_hdr_id);
3957: l_err_msg := FND_MESSAGE.GET;
3958:
3959: ADD_MSG_COLL_HIST ( l_err_msg ,
3960: p_hdr_rec.transaction_type,
3961: p_hdr_rec.lot_number,

Line 3999: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_CORR_REC_FAILED');

3995: x_resultout := 'FAILED';
3996:
3997: WHEN CORR_REC_FAILED THEN
3998:
3999: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_CORR_REC_FAILED');
4000:
4001: l_interface_err := FND_MESSAGE.GET;
4002:
4003: l_err_msg := g_exception_tracking_msg || ':' || l_interface_err;

Line 4001: l_interface_err := FND_MESSAGE.GET;

3997: WHEN CORR_REC_FAILED THEN
3998:
3999: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_CORR_REC_FAILED');
4000:
4001: l_interface_err := FND_MESSAGE.GET;
4002:
4003: l_err_msg := g_exception_tracking_msg || ':' || l_interface_err;
4004:
4005: IF (g_debug_level <= 5) THEN

Line 4039: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_TXN_FAILED');

4035: UPDATE_STATUS_FLAG(p_hdr_rec.msg_id,p_hdr_rec.hdr_id,'I',l_err_msg,l_trx_hdr_id);
4036:
4037: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'NOTIF_CODE','7B1_NOTIF2');
4038:
4039: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_TXN_FAILED');
4040: FND_MESSAGE.SET_TOKEN('GRP_ID',l_trx_hdr_id);
4041: l_err_msg := FND_MESSAGE.GET;
4042:
4043: ADD_MSG_COLL_HIST ( l_err_msg ,

Line 4040: FND_MESSAGE.SET_TOKEN('GRP_ID',l_trx_hdr_id);

4036:
4037: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'NOTIF_CODE','7B1_NOTIF2');
4038:
4039: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_TXN_FAILED');
4040: FND_MESSAGE.SET_TOKEN('GRP_ID',l_trx_hdr_id);
4041: l_err_msg := FND_MESSAGE.GET;
4042:
4043: ADD_MSG_COLL_HIST ( l_err_msg ,
4044: p_hdr_rec.transaction_type,

Line 4041: l_err_msg := FND_MESSAGE.GET;

4037: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'NOTIF_CODE','7B1_NOTIF2');
4038:
4039: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_TXN_FAILED');
4040: FND_MESSAGE.SET_TOKEN('GRP_ID',l_trx_hdr_id);
4041: l_err_msg := FND_MESSAGE.GET;
4042:
4043: ADD_MSG_COLL_HIST ( l_err_msg ,
4044: p_hdr_rec.transaction_type,
4045: p_hdr_rec.lot_number,

Line 4275: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_TXN_TYPE_ERR');

4271: x_resultout);
4272:
4273: ELSE
4274:
4275: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_TXN_TYPE_ERR');
4276: FND_MESSAGE.SET_TOKEN('TRX_TYPE',l_hdr_rec.transaction_type);
4277: FND_MESSAGE.SET_TOKEN('LOT_CLASS_CODE',l_qty_rec.lot_classification_code);
4278: FND_MESSAGE.SET_TOKEN('STATUS_CH_CODE',l_hdr_rec.status_change_code);
4279:

Line 4276: FND_MESSAGE.SET_TOKEN('TRX_TYPE',l_hdr_rec.transaction_type);

4272:
4273: ELSE
4274:
4275: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_TXN_TYPE_ERR');
4276: FND_MESSAGE.SET_TOKEN('TRX_TYPE',l_hdr_rec.transaction_type);
4277: FND_MESSAGE.SET_TOKEN('LOT_CLASS_CODE',l_qty_rec.lot_classification_code);
4278: FND_MESSAGE.SET_TOKEN('STATUS_CH_CODE',l_hdr_rec.status_change_code);
4279:
4280: l_coll_hist_msg := FND_MESSAGE.GET;

Line 4277: FND_MESSAGE.SET_TOKEN('LOT_CLASS_CODE',l_qty_rec.lot_classification_code);

4273: ELSE
4274:
4275: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_TXN_TYPE_ERR');
4276: FND_MESSAGE.SET_TOKEN('TRX_TYPE',l_hdr_rec.transaction_type);
4277: FND_MESSAGE.SET_TOKEN('LOT_CLASS_CODE',l_qty_rec.lot_classification_code);
4278: FND_MESSAGE.SET_TOKEN('STATUS_CH_CODE',l_hdr_rec.status_change_code);
4279:
4280: l_coll_hist_msg := FND_MESSAGE.GET;
4281:

Line 4278: FND_MESSAGE.SET_TOKEN('STATUS_CH_CODE',l_hdr_rec.status_change_code);

4274:
4275: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_TXN_TYPE_ERR');
4276: FND_MESSAGE.SET_TOKEN('TRX_TYPE',l_hdr_rec.transaction_type);
4277: FND_MESSAGE.SET_TOKEN('LOT_CLASS_CODE',l_qty_rec.lot_classification_code);
4278: FND_MESSAGE.SET_TOKEN('STATUS_CH_CODE',l_hdr_rec.status_change_code);
4279:
4280: l_coll_hist_msg := FND_MESSAGE.GET;
4281:
4282: ADD_MSG_COLL_HIST ( l_coll_hist_msg ,

Line 4280: l_coll_hist_msg := FND_MESSAGE.GET;

4276: FND_MESSAGE.SET_TOKEN('TRX_TYPE',l_hdr_rec.transaction_type);
4277: FND_MESSAGE.SET_TOKEN('LOT_CLASS_CODE',l_qty_rec.lot_classification_code);
4278: FND_MESSAGE.SET_TOKEN('STATUS_CH_CODE',l_hdr_rec.status_change_code);
4279:
4280: l_coll_hist_msg := FND_MESSAGE.GET;
4281:
4282: ADD_MSG_COLL_HIST ( l_coll_hist_msg ,
4283: l_hdr_rec.transaction_type,
4284: l_hdr_rec.lot_number,

Line 4319: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_INVALID_FRM_ORG');

4315: cln_debug_pub.Add('----Exception in procedure PROCESS_STAGING------',5);
4316: cln_debug_pub.Add('Invalid Transfer From ORG ID', 5);
4317: END IF;
4318:
4319: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_INVALID_FRM_ORG');
4320: FND_MESSAGE.SET_TOKEN('ORG_ID',l_hdr_rec.TRANSFER_FROM_ORG);
4321:
4322: l_coll_hist_msg := FND_MESSAGE.GET;
4323:

Line 4320: FND_MESSAGE.SET_TOKEN('ORG_ID',l_hdr_rec.TRANSFER_FROM_ORG);

4316: cln_debug_pub.Add('Invalid Transfer From ORG ID', 5);
4317: END IF;
4318:
4319: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_INVALID_FRM_ORG');
4320: FND_MESSAGE.SET_TOKEN('ORG_ID',l_hdr_rec.TRANSFER_FROM_ORG);
4321:
4322: l_coll_hist_msg := FND_MESSAGE.GET;
4323:
4324: ADD_MSG_COLL_HIST ( l_coll_hist_msg ,

Line 4322: l_coll_hist_msg := FND_MESSAGE.GET;

4318:
4319: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_INVALID_FRM_ORG');
4320: FND_MESSAGE.SET_TOKEN('ORG_ID',l_hdr_rec.TRANSFER_FROM_ORG);
4321:
4322: l_coll_hist_msg := FND_MESSAGE.GET;
4323:
4324: ADD_MSG_COLL_HIST ( l_coll_hist_msg ,
4325: l_hdr_rec.transaction_type,
4326: l_hdr_rec.lot_number,

Line 4351: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_UNEXPECTED_ERR');

4347: cln_debug_pub.Add('Error is ' || g_error_code || ':' || g_errmsg, 5);
4348: cln_debug_pub.Add('x_resultout : '|| x_resultout, 5);
4349: END IF;
4350:
4351: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_UNEXPECTED_ERR');
4352: FND_MESSAGE.SET_TOKEN('HDR_ID', l_hdr_rec.hdr_id);
4353:
4354: l_coll_hist_msg := FND_MESSAGE.GET;
4355:

Line 4352: FND_MESSAGE.SET_TOKEN('HDR_ID', l_hdr_rec.hdr_id);

4348: cln_debug_pub.Add('x_resultout : '|| x_resultout, 5);
4349: END IF;
4350:
4351: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_UNEXPECTED_ERR');
4352: FND_MESSAGE.SET_TOKEN('HDR_ID', l_hdr_rec.hdr_id);
4353:
4354: l_coll_hist_msg := FND_MESSAGE.GET;
4355:
4356: ADD_MSG_COLL_HIST ( l_coll_hist_msg ,

Line 4354: l_coll_hist_msg := FND_MESSAGE.GET;

4350:
4351: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_UNEXPECTED_ERR');
4352: FND_MESSAGE.SET_TOKEN('HDR_ID', l_hdr_rec.hdr_id);
4353:
4354: l_coll_hist_msg := FND_MESSAGE.GET;
4355:
4356: ADD_MSG_COLL_HIST ( l_coll_hist_msg ,
4357: l_hdr_rec.transaction_type,
4358: l_hdr_rec.lot_number,

Line 4535: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_TXN_FAILED');

4531: WHERE msg_id = l_msg_id
4532: AND hdr_id = l_rec.hdr_id;
4533:
4534:
4535: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_TXN_FAILED');
4536: FND_MESSAGE.SET_TOKEN('GRP_ID',l_rec.group_id);
4537: l_err_msg := FND_MESSAGE.GET;
4538:
4539: ADD_MSG_COLL_HIST ( l_err_msg ,

Line 4536: FND_MESSAGE.SET_TOKEN('GRP_ID',l_rec.group_id);

4532: AND hdr_id = l_rec.hdr_id;
4533:
4534:
4535: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_TXN_FAILED');
4536: FND_MESSAGE.SET_TOKEN('GRP_ID',l_rec.group_id);
4537: l_err_msg := FND_MESSAGE.GET;
4538:
4539: ADD_MSG_COLL_HIST ( l_err_msg ,
4540: l_rec.transaction_type,

Line 4537: l_err_msg := FND_MESSAGE.GET;

4533:
4534:
4535: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_TXN_FAILED');
4536: FND_MESSAGE.SET_TOKEN('GRP_ID',l_rec.group_id);
4537: l_err_msg := FND_MESSAGE.GET;
4538:
4539: ADD_MSG_COLL_HIST ( l_err_msg ,
4540: l_rec.transaction_type,
4541: l_rec.lot_number,

Line 4603: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_MSG_SUCCESS');

4599: IF l_get_notif_code IS NULL THEN -- no err in the trx processing
4600:
4601: wf_engine.SetItemAttrText(p_itemtype,p_itemkey,'NOTIF_CODE','7B1_NOTIF3');
4602:
4603: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_MSG_SUCCESS');
4604: l_err_msg := FND_MESSAGE.GET;
4605:
4606: wf_engine.SetItemAttrText(p_itemtype,p_itemkey,'NOTIF_DESC',l_err_msg);
4607:

Line 4604: l_err_msg := FND_MESSAGE.GET;

4600:
4601: wf_engine.SetItemAttrText(p_itemtype,p_itemkey,'NOTIF_CODE','7B1_NOTIF3');
4602:
4603: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_MSG_SUCCESS');
4604: l_err_msg := FND_MESSAGE.GET;
4605:
4606: wf_engine.SetItemAttrText(p_itemtype,p_itemkey,'NOTIF_DESC',l_err_msg);
4607:
4608: l_update_cln_parameter_list := wf_parameter_list_t();

Line 4617: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_MSG_FAILED');

4613:
4614:
4615: ELSE -- some trx erred out
4616:
4617: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_MSG_FAILED');
4618: l_err_msg := FND_MESSAGE.GET;
4619:
4620: wf_engine.SetItemAttrText(p_itemtype,p_itemkey,'NOTIF_DESC',l_err_msg);
4621:

Line 4618: l_err_msg := FND_MESSAGE.GET;

4614:
4615: ELSE -- some trx erred out
4616:
4617: FND_MESSAGE.SET_NAME('CLN','M4R_7B1_OSFM_MSG_FAILED');
4618: l_err_msg := FND_MESSAGE.GET;
4619:
4620: wf_engine.SetItemAttrText(p_itemtype,p_itemkey,'NOTIF_DESC',l_err_msg);
4621:
4622: l_update_cln_parameter_list := wf_parameter_list_t();