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.OE_CREDIT_CHECK_ORDER_PVT dependencies on OE_MSG_PUB

Line 198: OE_MSG_PUB.Add_Exc_Msg

194: EXCEPTION
195: WHEN OTHERS THEN
196: OE_DEBUG_PUB.ADD(SUBSTR(SQLERRM,1,300) ) ;
197:
198: OE_MSG_PUB.Add_Exc_Msg
199: ( G_PKG_NAME
200: , 'Check_Manual_Released_Holds'
201: );
202:

Line 287: OE_MSG_PUB.Add_Exc_Msg

283: END IF;
284:
285: EXCEPTION
286: WHEN OTHERS THEN
287: OE_MSG_PUB.Add_Exc_Msg
288: ( G_PKG_NAME
289: , 'Hold_Exists'
290: );
291:

Line 324: OE_MSG_PUB.Add;

320:
321: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_REMOVED');
322: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);
323: FND_MESSAGE.Set_Token('LINE_NUMBER',p_line_number);
324: OE_MSG_PUB.Add;
325: ---OE_MSG_PUB.Save_Messages(1);
326:
327: IF G_debug_flag = 'Y'
328: THEN

Line 325: ---OE_MSG_PUB.Save_Messages(1);

321: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_REMOVED');
322: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);
323: FND_MESSAGE.Set_Token('LINE_NUMBER',p_line_number);
324: OE_MSG_PUB.Add;
325: ---OE_MSG_PUB.Save_Messages(1);
326:
327: IF G_debug_flag = 'Y'
328: THEN
329: OE_DEBUG_PUB.Add('OEXVCRHB: Out Write_Release_Message');

Line 333: OE_MSG_PUB.Add_Exc_Msg

329: OE_DEBUG_PUB.Add('OEXVCRHB: Out Write_Release_Message');
330: END IF;
331: EXCEPTION
332: WHEN OTHERS THEN
333: OE_MSG_PUB.Add_Exc_Msg
334: ( G_PKG_NAME
335: , 'Write_Release_Message'
336: );
337:

Line 391: OE_MSG_PUB.Add;

387: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_MSG');
388: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
389: --6616741 FND_MESSAGE.Set_Token('CC_PROFILE',p_cc_profile_used);
390: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used); --6616741
391: OE_MSG_PUB.Add;
392: ELSE
393: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_'||p_cc_limit_used||'_'||
394: p_cc_profile_used);
395: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);

Line 398: OE_MSG_PUB.Add;

394: p_cc_profile_used);
395: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
396: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_'||p_cc_limit_used||'_'||
397: p_cc_profile_used);
398: OE_MSG_PUB.Add;
399: END IF;
400: ELSE
401: --bug4583872
402: IF INSTR(p_cc_limit_used, ',') > 0 THEN

Line 410: OE_MSG_PUB.Add;

406: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
407: FND_MESSAGE.Set_Name('ONT','OE_CC_EXT_MSG');
408: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
409: FND_MESSAGE.Set_Token('CC_PROFILE',p_cc_profile_used);
410: OE_MSG_PUB.Add;
411: ELSE
412: FND_MESSAGE.Set_Name('ONT','OE_CC_EXT_'||p_cc_limit_used||'_'||
413: p_cc_profile_used);
414: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);

Line 417: OE_MSG_PUB.Add;

413: p_cc_profile_used);
414: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
415: FND_MESSAGE.Set_Name('ONT','OE_CC_EXT_'||p_cc_limit_used||'_'||
416: p_cc_profile_used);
417: OE_MSG_PUB.Add;
418: END IF;
419: END IF;
420: ELSE
421: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_'||p_cc_limit_used||'_CATEGORY');

Line 427: OE_MSG_PUB.Add;

423: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
424: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_'||p_cc_limit_used||'_'||
425: 'CATEGORY');
426: FND_MESSAGE.Set_Token('CATEGORY',p_item_category);
427: OE_MSG_PUB.Add;
428: END IF;
429: --
430: -- Write to logfile if original call was from a concurrent program
431: --

Line 464: OE_MSG_PUB.Add_Exc_Msg

460: END IF;
461:
462: EXCEPTION
463: WHEN OTHERS THEN
464: OE_MSG_PUB.Add_Exc_Msg
465: ( G_PKG_NAME
466: , 'Write_Order_Hold_Msg'
467: );
468:

Line 493: OE_MSG_PUB.Add;

489: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Order '||TO_CHAR(p_order_number)
490: ||': Credit check hold released.');
491: ELSE
492: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_REMOVED');
493: OE_MSG_PUB.Add;
494: END IF;
495: --
496: IF G_debug_flag = 'Y'
497: THEN

Line 503: OE_MSG_PUB.Add_Exc_Msg

499: END IF;
500:
501: EXCEPTION
502: WHEN OTHERS THEN
503: OE_MSG_PUB.Add_Exc_Msg
504: ( G_PKG_NAME
505: , 'Write_Order_Release_Msg'
506: );
507:

Line 566: OE_MSG_PUB.Add_Exc_Msg

562: WHEN OTHERS THEN
563: rollback;
564: OE_DEBUG_PUB.ADD(' Error in Apply_hold_and_commit ' );
565: OE_DEBUG_PUB.ADD(' SQLERRM: '|| SQLERRM );
566: OE_MSG_PUB.Add_Exc_Msg
567: ( G_PKG_NAME
568: , 'Apply_hold_and_commit'
569: );
570:

Line 635: OE_MSG_PUB.Add_Exc_Msg

631: WHEN OTHERS THEN
632: rollback;
633: OE_DEBUG_PUB.ADD('OEXVCRHB: Error in Update_Comments_And_Commit' );
634: OE_DEBUG_PUB.ADD('SQLERRM: '|| SQLERRM );
635: OE_MSG_PUB.Add_Exc_Msg
636: ( G_PKG_NAME
637: , 'Update_Comments_And_Commit'
638: );
639:

Line 876: OE_MSG_PUB.Add_Exc_Msg

872: END IF;
873:
874: EXCEPTION
875: WHEN OTHERS THEN
876: OE_MSG_PUB.Add_Exc_Msg
877: ( G_PKG_NAME
878: , 'Apply_Order_CC_Hold'
879: );
880:

Line 996: OE_MSG_PUB.Add_Exc_Msg

992: OE_DEBUG_PUB.Add('OEXVCRHB: Out Release_Order_CC_Hold');
993: END IF;
994: EXCEPTION
995: WHEN OTHERS THEN
996: OE_MSG_PUB.Add_Exc_Msg
997: ( G_PKG_NAME
998: , 'Release_Order_CC_Hold'
999: );
1000:

Line 1086: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1082: END IF;
1083: EXCEPTION
1084: WHEN OTHERS THEN
1085: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1086: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1087: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Chk_Past_Due_invoice');
1088: END IF;
1089: END Chk_Past_Due_Invoice;
1090:

Line 1087: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Chk_Past_Due_invoice');

1083: EXCEPTION
1084: WHEN OTHERS THEN
1085: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1086: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1087: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Chk_Past_Due_invoice');
1088: END IF;
1089: END Chk_Past_Due_Invoice;
1090:
1091: --------------------------------------------------------------

Line 1258: OE_MSG_PUB.ADD;

1254: FND_MESSAGE.Set_Token('FROM',p_header_rec.transactional_curr_code);
1255: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );
1256: FND_MESSAGE.Set_Token('CONV',
1257: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate'));
1258: OE_MSG_PUB.ADD;
1259:
1260: G_result_out := 'FAIL' ;
1261: x_cc_result_out := 'FAIL';
1262: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1281: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1277: EXCEPTION
1278: WHEN others THEN
1279: OE_DEBUG_PUB.Add('Check_Trx_Limit: Other exceptions');
1280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1281: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1282: OE_MSG_PUB.Add_Exc_Msg
1283: ( G_PKG_NAME
1284: , 'Check_Trx_Limit'
1285: );

Line 1282: OE_MSG_PUB.Add_Exc_Msg

1278: WHEN others THEN
1279: OE_DEBUG_PUB.Add('Check_Trx_Limit: Other exceptions');
1280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1281: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1282: OE_MSG_PUB.Add_Exc_Msg
1283: ( G_PKG_NAME
1284: , 'Check_Trx_Limit'
1285: );
1286: END IF;

Line 1358: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1354:
1355: EXCEPTION
1356: WHEN others THEN
1357: OE_DEBUG_PUB.Add('check_credit_check_flags: Other exceptions');
1358: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1359: OE_MSG_PUB.Add_Exc_Msg
1360: ( G_PKG_NAME
1361: , 'check_credit_check_flags'
1362: );

Line 1359: OE_MSG_PUB.Add_Exc_Msg

1355: EXCEPTION
1356: WHEN others THEN
1357: OE_DEBUG_PUB.Add('check_credit_check_flags: Other exceptions');
1358: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1359: OE_MSG_PUB.Add_Exc_Msg
1360: ( G_PKG_NAME
1361: , 'check_credit_check_flags'
1362: );
1363: END IF;

Line 1557: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1553:
1554: EXCEPTION
1555: WHEN OTHERS THEN
1556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1557: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1558: OE_MSG_PUB.Add_Exc_Msg
1559: ( G_PKG_NAME
1560: , 'Validate_other_credit_check'
1561: );

Line 1558: OE_MSG_PUB.Add_Exc_Msg

1554: EXCEPTION
1555: WHEN OTHERS THEN
1556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1557: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1558: OE_MSG_PUB.Add_Exc_Msg
1559: ( G_PKG_NAME
1560: , 'Validate_other_credit_check'
1561: );
1562: END IF;

Line 1940: OE_MSG_PUB.ADD;

1936: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );
1937: FND_MESSAGE.Set_Token('CONV',
1938: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate')) ;
1939:
1940: OE_MSG_PUB.ADD;
1941:
1942: G_result_out := 'FAIL' ;
1943: x_cc_result_out := 'FAIL';
1944: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1975: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1971: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1972: IF G_debug_flag = 'Y' THEN
1973: OE_DEBUG_PUB.Add('Check_order_exposure: Other exceptions');
1974: END IF;
1975: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1976: OE_MSG_PUB.Add_Exc_Msg
1977: ( G_PKG_NAME
1978: , 'Check_order_exposure'
1979: );

Line 1976: OE_MSG_PUB.Add_Exc_Msg

1972: IF G_debug_flag = 'Y' THEN
1973: OE_DEBUG_PUB.Add('Check_order_exposure: Other exceptions');
1974: END IF;
1975: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1976: OE_MSG_PUB.Add_Exc_Msg
1977: ( G_PKG_NAME
1978: , 'Check_order_exposure'
1979: );
1980: END IF;

Line 2177: OE_MSG_PUB.ADD ;

2173: FND_MESSAGE.Set_Token('TO',l_limit_curr );
2174: FND_MESSAGE.Set_Token('CONV',
2175: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate')) ;
2176:
2177: OE_MSG_PUB.ADD ;
2178:
2179: G_result_out := 'FAIL' ;
2180: x_cc_result_out := 'FAIL';
2181: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2195: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2191: IF G_debug_flag = 'Y' THEN
2192: OE_DEBUG_PUB.Add('Check_Item_Limit: Other exceptions');
2193: END IF;
2194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2195: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2196: OE_MSG_PUB.Add_Exc_Msg
2197: ( G_PKG_NAME
2198: , 'Check_Item_Limits'
2199: );

Line 2196: OE_MSG_PUB.Add_Exc_Msg

2192: OE_DEBUG_PUB.Add('Check_Item_Limit: Other exceptions');
2193: END IF;
2194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2195: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2196: OE_MSG_PUB.Add_Exc_Msg
2197: ( G_PKG_NAME
2198: , 'Check_Item_Limits'
2199: );
2200: END IF;

Line 2759: OE_MSG_PUB.Add;

2755: THEN
2756:
2757: FND_MESSAGE.Set_Name('ONT','OE_CC_CMGT_REVIEW');
2758: FND_MESSAGE.Set_Token('REQUEST_ID',l_request_id);
2759: OE_MSG_PUB.Add;
2760:
2761: END IF;
2762:
2763: IF G_debug_flag = 'Y'

Line 2823: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2819: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2820: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2821: WHEN OTHERS THEN
2822: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2823: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2824: OE_MSG_PUB.Add_Exc_Msg
2825: ( G_PKG_NAME, 'Check_Other_Credit_Limits');
2826: END IF;
2827: IF G_debug_flag = 'Y' THEN

Line 2824: OE_MSG_PUB.Add_Exc_Msg

2820: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2821: WHEN OTHERS THEN
2822: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2823: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2824: OE_MSG_PUB.Add_Exc_Msg
2825: ( G_PKG_NAME, 'Check_Other_Credit_Limits');
2826: END IF;
2827: IF G_debug_flag = 'Y' THEN
2828: OE_DEBUG_PUB.Add( SUBSTR(SQLERRM,1,300),1 ) ;

Line 3162: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3158: IF G_debug_flag = 'Y' THEN
3159: OE_DEBUG_PUB.Add('Check_order_credit: Other Unexpected Error ');
3160: END IF;
3161: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3162: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3163: OE_MSG_PUB.Add_Exc_Msg
3164: ( G_PKG_NAME
3165: , 'Check_order_credit'
3166: );

Line 3163: OE_MSG_PUB.Add_Exc_Msg

3159: OE_DEBUG_PUB.Add('Check_order_credit: Other Unexpected Error ');
3160: END IF;
3161: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3162: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3163: OE_MSG_PUB.Add_Exc_Msg
3164: ( G_PKG_NAME
3165: , 'Check_order_credit'
3166: );
3167: END IF;

Line 3171: OE_MSG_PUB.Count_And_Get

3167: END IF;
3168: IF G_debug_flag = 'Y' THEN
3169: OE_DEBUG_PUB.Add( SUBSTR(SQLERRM,1,300),1 ) ;
3170: END IF;
3171: OE_MSG_PUB.Count_And_Get
3172: ( p_count => x_msg_count
3173: , p_data => x_msg_data
3174: );
3175: