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_LINES_PVT dependencies on OE_MSG_PUB

Line 133: OE_MSG_PUB.Add_Exc_Msg

129: WHEN OTHERS THEN
130: rollback;
131: OE_DEBUG_PUB.ADD(' Error in Apply_hold_and_commit ' );
132: OE_DEBUG_PUB.ADD(' SQLERRM: '|| SQLERRM );
133: OE_MSG_PUB.Add_Exc_Msg
134: ( G_PKG_NAME
135: , 'Apply_hold_and_commit'
136: );
137:

Line 203: OE_MSG_PUB.Add_Exc_Msg

199: WHEN OTHERS THEN
200: rollback;
201: OE_DEBUG_PUB.ADD('OEXVCRLB: Error in Update_Comments_And_Commit' );
202: OE_DEBUG_PUB.ADD('SQLERRM: '|| SQLERRM );
203: OE_MSG_PUB.Add_Exc_Msg
204: ( G_PKG_NAME
205: , 'Update_Comments_And_Commit'
206: );
207:

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

447: END IF;
448:
449: EXCEPTION
450: WHEN OTHERS THEN
451: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
452: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Create_Holds_Table');
453: END IF;
454: RAISE;
455:

Line 452: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Create_Holds_Table');

448:
449: EXCEPTION
450: WHEN OTHERS THEN
451: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
452: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Create_Holds_Table');
453: END IF;
454: RAISE;
455:
456: END Create_Holds_Table ;

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

551:
552: EXCEPTION
553: WHEN OTHERS THEN
554: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
555: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
556: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Update_Holds_Table');
557: END IF;
558: RAISE;
559: END Update_Holds_Table;

Line 556: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Update_Holds_Table');

552: EXCEPTION
553: WHEN OTHERS THEN
554: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
555: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
556: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Update_Holds_Table');
557: END IF;
558: RAISE;
559: END Update_Holds_Table;
560:

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

622: OE_DEBUG_PUB.Add('OEXVCRLB: Out Update_Holds_Table');
623: END IF;
624: EXCEPTION
625: WHEN OTHERS THEN
626: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
627: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Update_Holds_Table overloaded');
628: END IF;
629: RAISE;
630: END Update_Holds_Table;

Line 627: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Update_Holds_Table overloaded');

623: END IF;
624: EXCEPTION
625: WHEN OTHERS THEN
626: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
627: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Update_Holds_Table overloaded');
628: END IF;
629: RAISE;
630: END Update_Holds_Table;
631: --ER 6135714------------------------------------------------------------------------------------

Line 757: OE_MSG_PUB.Add_Exc_Msg

753: RETURN l_manual_hold_exists ;
754:
755: EXCEPTION
756: WHEN OTHERS THEN
757: OE_MSG_PUB.Add_Exc_Msg
758: (G_PKG_NAME, 'Check_Manual_Released_Holds' );
759: RAISE;
760:
761: END Check_Manual_Released_Holds;

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

830:
831: EXCEPTION
832: WHEN OTHERS THEN
833: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
834: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
835: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Chk_Past_Due_invoice');
836: END IF;
837: END Chk_Past_Due_Invoice;
838:

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

831: EXCEPTION
832: WHEN OTHERS THEN
833: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
834: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
835: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Chk_Past_Due_invoice');
836: END IF;
837: END Chk_Past_Due_Invoice;
838:
839:

Line 923: OE_MSG_PUB.Add_Exc_Msg

919: END IF;
920:
921: EXCEPTION
922: WHEN OTHERS THEN
923: OE_MSG_PUB.Add_Exc_Msg
924: (G_PKG_NAME, 'Hold_Exists');
925: RAISE;
926:
927: END Hold_Exists;

Line 978: OE_MSG_PUB.Add;

974: FND_MESSAGE.Set_Token('ORDER_NUMBER' ,p_order_number);
975: FND_MESSAGE.Set_Token('LINE_NUMBER' ,p_line_number);
976: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
977: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used);
978: OE_MSG_PUB.Add;
979:
980: ELSE
981: IF p_cc_profile_used = 'SITE' THEN
982: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||

Line 996: OE_MSG_PUB.Add;

992: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);
993: FND_MESSAGE.Set_Token('LINE_NUMBER',p_line_number);
994: FND_MESSAGE.Set_Token('CUSTOMER_NAME',p_customer_name);
995: FND_MESSAGE.Set_Token('SITE_NAME' ,p_site_name);
996: OE_MSG_PUB.Add;
997: ELSIF p_cc_profile_used = 'CUSTOMER'
998: THEN
999: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
1000: p_cc_profile_used);

Line 1011: OE_MSG_PUB.Add;

1007: p_cc_profile_used);
1008: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);
1009: FND_MESSAGE.Set_Token('LINE_NUMBER',p_line_number);
1010: FND_MESSAGE.Set_Token('CUSTOMER_NAME',p_customer_name);
1011: OE_MSG_PUB.Add;
1012:
1013: ELSIF p_cc_profile_used = 'PARTY'
1014: THEN
1015: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||

Line 1027: OE_MSG_PUB.Add;

1023: p_cc_profile_used);
1024: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);
1025: FND_MESSAGE.Set_Token('LINE_NUMBER',p_line_number);
1026: FND_MESSAGE.Set_Token('PARTY_NAME',p_party_name) ;
1027: OE_MSG_PUB.Add;
1028:
1029: ELSIF p_cc_profile_used = 'DEFAULT' THEN
1030: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
1031: p_cc_profile_used);

Line 1040: OE_MSG_PUB.Add;

1036: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||
1037: p_cc_profile_used);
1038: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);
1039: FND_MESSAGE.Set_Token('LINE_NUMBER',p_line_number);
1040: OE_MSG_PUB.Add;
1041: END IF;
1042: END IF;
1043: ELSE
1044: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_'||p_cc_limit_used||'_'||

Line 1056: OE_MSG_PUB.Add;

1052: 'CATEGORY');
1053: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);
1054: FND_MESSAGE.Set_Token('LINE_NUMBER',p_line_number);
1055: FND_MESSAGE.Set_Token('CATEGORY',p_item_category);
1056: OE_MSG_PUB.Add;
1057: END IF;
1058: --END IF; -- bug 5467793
1059: --
1060: -- Save messages on message stack to message table

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

1059: --
1060: -- Save messages on message stack to message table
1061: -- Give a dummy request id
1062: -- rajesh
1063: --OE_MSG_PUB.Save_Messages(1);
1064: --OE_MSG_PUB.Delete_Msg(OE_MSG_PUB.G_msg_count);
1065: --
1066: -- Write to logfile if original call was from a concurrent program
1067: --

Line 1064: --OE_MSG_PUB.Delete_Msg(OE_MSG_PUB.G_msg_count);

1060: -- Save messages on message stack to message table
1061: -- Give a dummy request id
1062: -- rajesh
1063: --OE_MSG_PUB.Save_Messages(1);
1064: --OE_MSG_PUB.Delete_Msg(OE_MSG_PUB.G_msg_count);
1065: --
1066: -- Write to logfile if original call was from a concurrent program
1067: --
1068: IF p_calling_action = 'AUTO HOLD' THEN

Line 1099: OE_MSG_PUB.Add_Exc_Msg

1095: END IF;
1096:
1097: EXCEPTION
1098: WHEN OTHERS THEN
1099: OE_MSG_PUB.Add_Exc_Msg
1100: (G_PKG_NAME, 'Write_Hold_Message');
1101: RAISE;
1102:
1103: END Write_Hold_Message;

Line 1132: OE_MSG_PUB.Add;

1128:
1129: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_REMOVED');
1130: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);
1131: FND_MESSAGE.Set_Token('LINE_NUMBER',p_line_number);
1132: OE_MSG_PUB.Add;
1133: --- rajesh
1134: --OE_MSG_PUB.Save_Messages(1);
1135: --
1136: IF G_debug_flag = 'Y'

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

1130: FND_MESSAGE.Set_Token('ORDER_NUMBER',p_order_number);
1131: FND_MESSAGE.Set_Token('LINE_NUMBER',p_line_number);
1132: OE_MSG_PUB.Add;
1133: --- rajesh
1134: --OE_MSG_PUB.Save_Messages(1);
1135: --
1136: IF G_debug_flag = 'Y'
1137: THEN
1138: OE_DEBUG_PUB.Add('OEXVCRLB: Out Write_Release_Message');

Line 1143: OE_MSG_PUB.Add_Exc_Msg

1139: END IF;
1140:
1141: EXCEPTION
1142: WHEN OTHERS THEN
1143: OE_MSG_PUB.Add_Exc_Msg
1144: (G_PKG_NAME, 'Write_Release_Message');
1145: RAISE;
1146:
1147: END Write_Release_Message;

Line 1190: OE_MSG_PUB.Add;

1186: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
1187: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_MSG');
1188: FND_MESSAGE.Set_Token('LIMIT_USED',p_cc_limit_used);
1189: FND_MESSAGE.Set_Token('CC_PROFILE',l_cc_profile_used);
1190: OE_MSG_PUB.Add;
1191: ELSE
1192: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_'||p_cc_limit_used||'_'||
1193: p_cc_profile_used);
1194: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);

Line 1197: OE_MSG_PUB.Add;

1193: p_cc_profile_used);
1194: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
1195: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_'||p_cc_limit_used||'_'||
1196: p_cc_profile_used);
1197: OE_MSG_PUB.Add;
1198: END IF;
1199: ELSE
1200: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_'||p_cc_limit_used||'_CATEGORY');
1201: FND_MESSAGE.Set_Token('CATEGORY',p_item_category);

Line 1206: OE_MSG_PUB.Add;

1202: l_comment := SUBSTR(FND_MESSAGE.GET,1,2000);
1203: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_'||p_cc_limit_used||'_'||
1204: 'CATEGORY');
1205: FND_MESSAGE.Set_Token('CATEGORY',p_item_category);
1206: OE_MSG_PUB.Add;
1207: END IF;
1208: --
1209: -- Write to logfile if original call was from a concurrent program
1210: --

Line 1241: OE_MSG_PUB.Add_Exc_Msg

1237: END IF;
1238:
1239: EXCEPTION
1240: WHEN OTHERS THEN
1241: OE_MSG_PUB.Add_Exc_Msg
1242: (G_PKG_NAME, 'Write_Order_Hold_Msg');
1243: RAISE;
1244:
1245: END Write_Order_Hold_Msg;

Line 1267: OE_MSG_PUB.Add;

1263: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Order '||TO_CHAR(p_order_number)
1264: ||': Credit check hold released.');
1265: ELSE
1266: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_REMOVED');
1267: OE_MSG_PUB.Add;
1268: END IF;
1269: --
1270: IF G_debug_flag = 'Y'
1271: THEN

Line 1277: OE_MSG_PUB.Add_Exc_Msg

1273: END IF;
1274:
1275: EXCEPTION
1276: WHEN OTHERS THEN
1277: OE_MSG_PUB.Add_Exc_Msg
1278: (G_PKG_NAME, 'Write_Order_Release_Msg');
1279: RAISE;
1280:
1281: END Write_Order_Release_Msg;

Line 1593: OE_MSG_PUB.Add_Exc_Msg

1589:
1590:
1591: EXCEPTION
1592: WHEN OTHERS THEN
1593: OE_MSG_PUB.Add_Exc_Msg
1594: (G_PKG_NAME, 'Apply_Line_CC_Hold');
1595: RAISE;
1596:
1597: END Apply_Line_CC_Hold;

Line 1746: OE_MSG_PUB.Add_Exc_Msg

1742: END IF;
1743:
1744: EXCEPTION
1745: WHEN OTHERS THEN
1746: OE_MSG_PUB.Add_Exc_Msg
1747: (G_PKG_NAME, 'Apply_Order_CC_Hold' );
1748: RAISE;
1749:
1750: END Apply_Order_CC_Hold;

Line 1859: OE_MSG_PUB.Add_Exc_Msg

1855: END IF;
1856:
1857: EXCEPTION
1858: WHEN OTHERS THEN
1859: OE_MSG_PUB.Add_Exc_Msg
1860: (G_PKG_NAME, 'Release_Order_CC_Hold');
1861: RAISE;
1862:
1863: END Release_Order_CC_Hold;

Line 1913: OE_MSG_PUB.Add_Exc_Msg

1909: OE_DEBUG_PUB.Add('OEXVCRLB: Out Apply_Item_Category_Holds');
1910:
1911: EXCEPTION
1912: WHEN OTHERS THEN
1913: OE_MSG_PUB.Add_Exc_Msg
1914: (G_PKG_NAME, 'Apply_Item_Category_Holds');
1915: RAISE;
1916:
1917: END Apply_Item_Category_Holds;

Line 1960: OE_MSG_PUB.Add_Exc_Msg

1956: END IF;
1957:
1958: EXCEPTION
1959: WHEN OTHERS THEN
1960: OE_MSG_PUB.Add_Exc_Msg
1961: (G_PKG_NAME, 'Apply_Other_Holds');
1962: RAISE;
1963:
1964: END Apply_Other_Holds;

Line 2098: OE_MSG_PUB.Add_Exc_Msg

2094: END IF;
2095:
2096: EXCEPTION
2097: WHEN OTHERS THEN
2098: OE_MSG_PUB.Add_Exc_Msg
2099: (G_PKG_NAME, 'Release_Line_CC_Hold');
2100: RAISE;
2101:
2102: END Release_Line_CC_Hold;

Line 2237: OE_MSG_PUB.ADD;

2233: FND_MESSAGE.Set_Token('TO',p_limit_curr_code );
2234: FND_MESSAGE.Set_Token('CONV',
2235: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate'));
2236:
2237: OE_MSG_PUB.ADD;
2238: x_return_status := FND_API.G_RET_STS_ERROR;
2239:
2240: END IF;
2241:

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

2253: EXCEPTION
2254: WHEN others THEN
2255: OE_DEBUG_PUB.Add('Check_Trx_Limit: Other exceptions');
2256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2257: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2258: OE_MSG_PUB.Add_Exc_Msg
2259: ( G_PKG_NAME
2260: , 'Check_Trx_Limit'
2261: );

Line 2258: OE_MSG_PUB.Add_Exc_Msg

2254: WHEN others THEN
2255: OE_DEBUG_PUB.Add('Check_Trx_Limit: Other exceptions');
2256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2257: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2258: OE_MSG_PUB.Add_Exc_Msg
2259: ( G_PKG_NAME
2260: , 'Check_Trx_Limit'
2261: );
2262: END IF;

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

2418: END IF;
2419: EXCEPTION
2420: WHEN OTHERS THEN
2421: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2422: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2423: OE_MSG_PUB.Add_Exc_Msg
2424: ( G_PKG_NAME
2425: , 'Validate_other_credit_check'
2426: );

Line 2423: OE_MSG_PUB.Add_Exc_Msg

2419: EXCEPTION
2420: WHEN OTHERS THEN
2421: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2422: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2423: OE_MSG_PUB.Add_Exc_Msg
2424: ( G_PKG_NAME
2425: , 'Validate_other_credit_check'
2426: );
2427: END IF;

Line 2658: OE_MSG_PUB.ADD;

2654: FND_MESSAGE.Set_Token('CONV',
2655: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate'));
2656:
2657:
2658: OE_MSG_PUB.ADD;
2659: x_return_status := FND_API.G_RET_STS_ERROR;
2660: OE_DEBUG_PUB.ADD('Return status after assigned as Error = '
2661: || x_return_status );
2662: END IF;

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

2683: EXCEPTION
2684: WHEN others THEN
2685: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2686: OE_DEBUG_PUB.Add('CHECK_ORDER_LINES_EXPOSURE: Other exceptions');
2687: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2688: OE_MSG_PUB.Add_Exc_Msg
2689: ( G_PKG_NAME
2690: , 'CHECK_ORDER_LINES_EXPOSURE'
2691: );

Line 2688: OE_MSG_PUB.Add_Exc_Msg

2684: WHEN others THEN
2685: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2686: OE_DEBUG_PUB.Add('CHECK_ORDER_LINES_EXPOSURE: Other exceptions');
2687: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2688: OE_MSG_PUB.Add_Exc_Msg
2689: ( G_PKG_NAME
2690: , 'CHECK_ORDER_LINES_EXPOSURE'
2691: );
2692: END IF;

Line 2900: OE_MSG_PUB.ADD ;

2896: FND_MESSAGE.Set_Token('TO',l_limit_currency );
2897: FND_MESSAGE.Set_Token('CONV',
2898: NVL(p_credit_check_rule_rec.user_conversion_type,'Corporate'));
2899:
2900: OE_MSG_PUB.ADD ;
2901: x_return_status := FND_API.G_RET_STS_ERROR;
2902: OE_DEBUG_PUB.ADD('Return status after assigned as Error = '
2903: || x_return_status );
2904: END IF;

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

2908:
2909: WHEN others THEN
2910: OE_DEBUG_PUB.Add('Check_Item_Limit: Other exceptions');
2911: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2912: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2913: OE_MSG_PUB.Add_Exc_Msg
2914: ( G_PKG_NAME
2915: , 'Check_Item_Limits'
2916: );

Line 2913: OE_MSG_PUB.Add_Exc_Msg

2909: WHEN others THEN
2910: OE_DEBUG_PUB.Add('Check_Item_Limit: Other exceptions');
2911: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2912: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2913: OE_MSG_PUB.Add_Exc_Msg
2914: ( G_PKG_NAME
2915: , 'Check_Item_Limits'
2916: );
2917: END IF;

Line 3504: OE_MSG_PUB.Add;

3500: IF x_return_status='S'
3501: THEN
3502: FND_MESSAGE.Set_Name('ONT','OE_CC_CMGT_REVIEW');
3503: FND_MESSAGE.Set_Token('REQUEST_ID',l_request_id);
3504: OE_MSG_PUB.Add;
3505: END IF;
3506:
3507: IF G_debug_flag = 'Y'
3508: THEN

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

3594: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3595: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3596: WHEN OTHERS THEN
3597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3598: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3599: OE_MSG_PUB.Add_Exc_Msg
3600: ( G_PKG_NAME, 'Check_Other_Credit_Limits');
3601: END IF;
3602: OE_DEBUG_PUB.ADD( SUBSTR(SQLERRM,1,300),1 ) ;

Line 3599: OE_MSG_PUB.Add_Exc_Msg

3595: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3596: WHEN OTHERS THEN
3597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3598: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3599: OE_MSG_PUB.Add_Exc_Msg
3600: ( G_PKG_NAME, 'Check_Other_Credit_Limits');
3601: END IF;
3602: OE_DEBUG_PUB.ADD( SUBSTR(SQLERRM,1,300),1 ) ;
3603:

Line 3649: OE_MSG_PUB.Set_Msg_Context(

3645: IF p_holds_table(i).hold IS NOT NULL
3646: THEN
3647:
3648: --bug 4503551
3649: OE_MSG_PUB.Set_Msg_Context(
3650: p_entity_code => 'LINE'
3651: ,p_entity_id => p_holds_table(i).line_id
3652: ,p_header_id => p_header_id
3653: ,p_line_id => p_holds_table(i).line_id );

Line 3683: OE_MSG_PUB.Reset_Msg_Context('LINE'); --bug 4503551

3679: IF l_result_out = 'FAIL_HOLD' THEN
3680: l_cc_result_out := l_result_out;
3681: END IF;
3682:
3683: OE_MSG_PUB.Reset_Msg_Context('LINE'); --bug 4503551
3684:
3685: ELSIF p_check_exposure_mode = 'INLINE' OR
3686: p_check_exposure_mode = 'NOCHECK'
3687: THEN

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

3764: END IF;
3765: EXCEPTION
3766: WHEN others THEN
3767: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3768: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3769: OE_MSG_PUB.Add_Exc_Msg
3770: ( G_PKG_NAME
3771: , 'Apply_And_Release_Holds'
3772: );

Line 3769: OE_MSG_PUB.Add_Exc_Msg

3765: EXCEPTION
3766: WHEN others THEN
3767: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3768: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3769: OE_MSG_PUB.Add_Exc_Msg
3770: ( G_PKG_NAME
3771: , 'Apply_And_Release_Holds'
3772: );
3773: END IF;

Line 4321: OE_MSG_PUB.Set_Msg_Context(

4317: IF x_return_status='S'
4318: THEN
4319:
4320: --bug 4503551
4321: OE_MSG_PUB.Set_Msg_Context(
4322: p_entity_code => 'HEADER'
4323: ,p_entity_id => p_header_rec.header_id
4324: ,p_header_id => p_header_rec.header_id );
4325:

Line 4328: OE_MSG_PUB.Add;

4324: ,p_header_id => p_header_rec.header_id );
4325:
4326: FND_MESSAGE.Set_Name('ONT','OE_CC_CMGT_REVIEW');
4327: FND_MESSAGE.Set_Token('REQUEST_ID',l_request_id);
4328: OE_MSG_PUB.Add;
4329: OE_MSG_PUB.Reset_Msg_Context('HEADER'); --bug 4503551
4330: END IF;
4331:
4332: IF G_debug_flag = 'Y'

Line 4329: OE_MSG_PUB.Reset_Msg_Context('HEADER'); --bug 4503551

4325:
4326: FND_MESSAGE.Set_Name('ONT','OE_CC_CMGT_REVIEW');
4327: FND_MESSAGE.Set_Token('REQUEST_ID',l_request_id);
4328: OE_MSG_PUB.Add;
4329: OE_MSG_PUB.Reset_Msg_Context('HEADER'); --bug 4503551
4330: END IF;
4331:
4332: IF G_debug_flag = 'Y'
4333: THEN

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

4433: --
4434: IF l_credit_hold_level = 'LINE'
4435: THEN
4436: -- fix bug 4558056
4437: -- OE_MSG_PUB.Save_Messages(1);
4438: -- OE_MSG_PUB.Delete_Msg(OE_MSG_PUB.G_msg_count);
4439:
4440: -- added OR condition for bug 5467793
4441: IF x_cc_result_out = 'FAIL'

Line 4438: -- OE_MSG_PUB.Delete_Msg(OE_MSG_PUB.G_msg_count);

4434: IF l_credit_hold_level = 'LINE'
4435: THEN
4436: -- fix bug 4558056
4437: -- OE_MSG_PUB.Save_Messages(1);
4438: -- OE_MSG_PUB.Delete_Msg(OE_MSG_PUB.G_msg_count);
4439:
4440: -- added OR condition for bug 5467793
4441: IF x_cc_result_out = 'FAIL'
4442: --OR( NVL(OE_credit_engine_GRP.G_delayed_request, FND_API.G_FALSE ) =

Line 4449: OE_MSG_PUB.Add;

4445: -- Display the general message for the user on the screen
4446:
4447: FND_MESSAGE.Set_Name('ONT','OE_CC_HLD_GENERAL_MSG');
4448:
4449: OE_MSG_PUB.Add;
4450: END IF;
4451:
4452: IF G_release_status = 'RELEASED'
4453: THEN

Line 4456: OE_MSG_PUB.Add;

4452: IF G_release_status = 'RELEASED'
4453: THEN
4454:
4455: FND_MESSAGE.Set_Name('ONT','OE_CC_HOLD_REMOVED');
4456: OE_MSG_PUB.Add;
4457:
4458: END IF;
4459:
4460: END IF;

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

4475: WHEN OTHERS THEN
4476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4477: OE_DEBUG_PUB.Add('Check_order_lines_credit: Other Unexpected Error ',1);
4478: OE_DEBUG_PUB.ADD( SUBSTR(SQLERRM,1,300),1 ) ;
4479: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4480: OE_MSG_PUB.Add_Exc_Msg
4481: ( G_PKG_NAME
4482: , 'Check_order_lines_credit'
4483: );

Line 4480: OE_MSG_PUB.Add_Exc_Msg

4476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4477: OE_DEBUG_PUB.Add('Check_order_lines_credit: Other Unexpected Error ',1);
4478: OE_DEBUG_PUB.ADD( SUBSTR(SQLERRM,1,300),1 ) ;
4479: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4480: OE_MSG_PUB.Add_Exc_Msg
4481: ( G_PKG_NAME
4482: , 'Check_order_lines_credit'
4483: );
4484: END IF;