DBA Data[Home] [Help]

APPS.OE_CREDIT_PUB dependencies on OE_MSG_PUB

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

68: EXCEPTION
69:
70: WHEN others THEN
71: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
72: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
73:
74: OE_MSG_PUB.Add_Exc_Msg
75: ( G_PKG_NAME
76: ,'chk_past_due_invoice'

Line 74: OE_MSG_PUB.Add_Exc_Msg

70: WHEN others THEN
71: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
72: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
73:
74: OE_MSG_PUB.Add_Exc_Msg
75: ( G_PKG_NAME
76: ,'chk_past_due_invoice'
77: );
78: END IF;

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

179: EXCEPTION
180:
181: WHEN others THEN
182: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
183: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
184: OE_MSG_PUB.Add_Exc_Msg
185: ( G_PKG_NAME
186: , 'Check_Trx_Limit'
187: );

Line 184: OE_MSG_PUB.Add_Exc_Msg

180:
181: WHEN others THEN
182: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
183: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
184: OE_MSG_PUB.Add_Exc_Msg
185: ( G_PKG_NAME
186: , 'Check_Trx_Limit'
187: );
188: END IF;

Line 359: OE_MSG_PUB.Count_And_Get

355: -- message data.
356: -- If more than 1 just return the count. The Calling routine has to get
357: -- the messages from the message stack.
358:
359: OE_MSG_PUB.Count_And_Get
360: ( p_count => p_msg_count
361: , p_data => p_msg_data
362: );
363:

Line 378: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

374: WHEN OTHERS THEN
375:
376: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
377:
378: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
379: THEN
380: OE_MSG_PUB.Add_Exc_Msg
381: ( G_PKG_NAME
382: , 'Check_Available_Credit'

Line 380: OE_MSG_PUB.Add_Exc_Msg

376: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
377:
378: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
379: THEN
380: OE_MSG_PUB.Add_Exc_Msg
381: ( G_PKG_NAME
382: , 'Check_Available_Credit'
383: );
384: END IF;

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

538: l_credit_check_lvl_out := 'CUSTOMER';
539:
540: WHEN OTHERS THEN
541:
542: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
543: OE_MSG_PUB.Add_Exc_Msg
544: ( G_PKG_NAME
545: , 'Check Order:Check Customer'
546: );

Line 543: OE_MSG_PUB.Add_Exc_Msg

539:
540: WHEN OTHERS THEN
541:
542: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
543: OE_MSG_PUB.Add_Exc_Msg
544: ( G_PKG_NAME
545: , 'Check Order:Check Customer'
546: );
547: END IF;

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

593: -- credit checking needed.
594: l_check_order := 'N';
595:
596: WHEN OTHERS THEN
597: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
598: OE_MSG_PUB.Add_Exc_Msg
599: ( G_PKG_NAME
600: , 'Check Order:Check Customer'
601: );

Line 598: OE_MSG_PUB.Add_Exc_Msg

594: l_check_order := 'N';
595:
596: WHEN OTHERS THEN
597: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
598: OE_MSG_PUB.Add_Exc_Msg
599: ( G_PKG_NAME
600: , 'Check Order:Check Customer'
601: );
602: END IF;

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

642:
643: EXCEPTION
644:
645: WHEN OTHERS THEN
646: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
647: OE_MSG_PUB.Add_Exc_Msg
648: ( G_PKG_NAME
649: , 'Check_Order: Check Terms'
650: );

Line 647: OE_MSG_PUB.Add_Exc_Msg

643: EXCEPTION
644:
645: WHEN OTHERS THEN
646: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
647: OE_MSG_PUB.Add_Exc_Msg
648: ( G_PKG_NAME
649: , 'Check_Order: Check Terms'
650: );
651: END IF;

Line 667: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

663: oe_debug_pub.ADD('check order after checking payment term :'|| l_check_order);
664: EXCEPTION
665:
666: WHEN OTHERS THEN
667: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
668: THEN
669: OE_MSG_PUB.Add_Exc_Msg
670: ( G_PKG_NAME
671: , 'Check_Order'

Line 669: OE_MSG_PUB.Add_Exc_Msg

665:
666: WHEN OTHERS THEN
667: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
668: THEN
669: OE_MSG_PUB.Add_Exc_Msg
670: ( G_PKG_NAME
671: , 'Check_Order'
672: );
673: END IF;

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

1623:
1624: EXCEPTION
1625:
1626: WHEN others THEN
1627: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1628: OE_MSG_PUB.Add_Exc_Msg
1629: ( G_PKG_NAME
1630: , 'Check_Exposure'
1631: );

Line 1628: OE_MSG_PUB.Add_Exc_Msg

1624: EXCEPTION
1625:
1626: WHEN others THEN
1627: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1628: OE_MSG_PUB.Add_Exc_Msg
1629: ( G_PKG_NAME
1630: , 'Check_Exposure'
1631: );
1632: END IF;

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

1688: EXCEPTION
1689:
1690: WHEN others THEN
1691: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1692: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1693:
1694: OE_MSG_PUB.Add_Exc_Msg
1695: ( G_PKG_NAME
1696: ,'chk_past_due_invoice'

Line 1694: OE_MSG_PUB.Add_Exc_Msg

1690: WHEN others THEN
1691: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1692: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1693:
1694: OE_MSG_PUB.Add_Exc_Msg
1695: ( G_PKG_NAME
1696: ,'chk_past_due_invoice'
1697: );
1698: END IF;

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

1825: EXCEPTION
1826:
1827: WHEN others THEN
1828: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1829: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1830: OE_MSG_PUB.Add_Exc_Msg
1831: ( G_PKG_NAME
1832: , 'Check_Trx_Limit_Line'
1833: );

Line 1830: OE_MSG_PUB.Add_Exc_Msg

1826:
1827: WHEN others THEN
1828: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1829: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1830: OE_MSG_PUB.Add_Exc_Msg
1831: ( G_PKG_NAME
1832: , 'Check_Trx_Limit_Line'
1833: );
1834: END IF;

Line 1903: --OE_MSG_PUB.ADD;

1899: EXCEPTION
1900: WHEN no_data_found then
1901: --x_return_status := FND_API.G_RET_STS_ERROR;
1902: --FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_SITE_USE_ID');
1903: --OE_MSG_PUB.ADD;
1904: --fnd_message.set_token('SITE_USE_ID',
1905: -- to_char(p_hold_entity_id));
1906: OE_Debug_PUB.Add('OEXPCRCB: Line Level: No Customer ID for Bill to:' ||
1907: to_char(p_invoice_to_org_id), 1);

Line 2034: OE_MSG_PUB.Count_And_Get

2030: -- message data.
2031: -- If more than 1 just return the count. The Calling routine has to get
2032: -- the messages from the message stack.
2033:
2034: OE_MSG_PUB.Count_And_Get
2035: ( p_count => p_msg_count
2036: , p_data => p_msg_data
2037: );
2038:

Line 2053: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2049: WHEN OTHERS THEN
2050:
2051: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2052:
2053: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2054: THEN
2055: OE_MSG_PUB.Add_Exc_Msg
2056: ( G_PKG_NAME
2057: , 'Check_Available_Credit'

Line 2055: OE_MSG_PUB.Add_Exc_Msg

2051: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2052:
2053: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2054: THEN
2055: OE_MSG_PUB.Add_Exc_Msg
2056: ( G_PKG_NAME
2057: , 'Check_Available_Credit'
2058: );
2059: END IF;

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

2200: -- limits are set at the customer level.
2201: oe_debug_pub.ADD('Line Level: Customer level credit check');
2202: l_credit_check_lvl_out := 'CUSTOMER';
2203: WHEN OTHERS THEN
2204: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2205: OE_MSG_PUB.Add_Exc_Msg
2206: ( G_PKG_NAME
2207: , 'Check Order:Check Customer'
2208: );

Line 2205: OE_MSG_PUB.Add_Exc_Msg

2201: oe_debug_pub.ADD('Line Level: Customer level credit check');
2202: l_credit_check_lvl_out := 'CUSTOMER';
2203: WHEN OTHERS THEN
2204: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2205: OE_MSG_PUB.Add_Exc_Msg
2206: ( G_PKG_NAME
2207: , 'Check Order:Check Customer'
2208: );
2209: END IF;

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

2258: -- credit checking needed.
2259: l_check_order := 'N';
2260:
2261: WHEN OTHERS THEN
2262: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2263: OE_MSG_PUB.Add_Exc_Msg
2264: ( G_PKG_NAME
2265: , 'Check Order:Check Customer'
2266: );

Line 2263: OE_MSG_PUB.Add_Exc_Msg

2259: l_check_order := 'N';
2260:
2261: WHEN OTHERS THEN
2262: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2263: OE_MSG_PUB.Add_Exc_Msg
2264: ( G_PKG_NAME
2265: , 'Check Order:Check Customer'
2266: );
2267: END IF;

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

2307: WHEN NO_DATA_FOUND THEN
2308: l_check_order := 'N';
2309: oe_debug_pub.ADD('Line does not have Payment Term subject to credit check');
2310: WHEN OTHERS THEN
2311: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2312: OE_MSG_PUB.Add_Exc_Msg
2313: ( G_PKG_NAME
2314: , 'Check_Order: Check Terms'
2315: );

Line 2312: OE_MSG_PUB.Add_Exc_Msg

2308: l_check_order := 'N';
2309: oe_debug_pub.ADD('Line does not have Payment Term subject to credit check');
2310: WHEN OTHERS THEN
2311: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2312: OE_MSG_PUB.Add_Exc_Msg
2313: ( G_PKG_NAME
2314: , 'Check_Order: Check Terms'
2315: );
2316: END IF;

Line 2331: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2327: oe_debug_pub.ADD('check order after checking payment term :'|| l_check_order);
2328: EXCEPTION
2329:
2330: WHEN OTHERS THEN
2331: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2332: THEN
2333: OE_MSG_PUB.Add_Exc_Msg
2334: ( G_PKG_NAME
2335: , 'Check_Order'

Line 2333: OE_MSG_PUB.Add_Exc_Msg

2329:
2330: WHEN OTHERS THEN
2331: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2332: THEN
2333: OE_MSG_PUB.Add_Exc_Msg
2334: ( G_PKG_NAME
2335: , 'Check_Order'
2336: );
2337: END IF;

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

3253:
3254:
3255: EXCEPTION
3256: WHEN others THEN
3257: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3258: OE_MSG_PUB.Add_Exc_Msg
3259: ( G_PKG_NAME
3260: , 'Check_Exposure'
3261: );

Line 3258: OE_MSG_PUB.Add_Exc_Msg

3254:
3255: EXCEPTION
3256: WHEN others THEN
3257: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3258: OE_MSG_PUB.Add_Exc_Msg
3259: ( G_PKG_NAME
3260: , 'Check_Exposure'
3261: );
3262: END IF;