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

Line 1834: OE_MSG_PUB.Count_And_Get

1830: x_return_status := FND_API.G_RET_STS_ERROR;
1831:
1832: -- Get message count and data
1833:
1834: OE_MSG_PUB.Count_And_Get
1835: ( p_count => x_msg_count
1836: , p_data => x_msg_data
1837: );
1838:

Line 1845: OE_MSG_PUB.Count_And_Get

1841: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1842:
1843: -- Get message count and data
1844:
1845: OE_MSG_PUB.Count_And_Get
1846: ( p_count => x_msg_count
1847: , p_data => x_msg_data
1848: );
1849:

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

1850: WHEN OTHERS THEN
1851:
1852: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1853:
1854: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1855: THEN
1856: OE_MSG_PUB.Add_Exc_Msg
1857: ( G_PKG_NAME
1858: , 'Process_Order'

Line 1856: OE_MSG_PUB.Add_Exc_Msg

1852: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1853:
1854: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1855: THEN
1856: OE_MSG_PUB.Add_Exc_Msg
1857: ( G_PKG_NAME
1858: , 'Process_Order'
1859: );
1860: END IF;

Line 1864: OE_MSG_PUB.Count_And_Get

1860: END IF;
1861:
1862: -- Get message count and data
1863:
1864: OE_MSG_PUB.Count_And_Get
1865: ( p_count => x_msg_count
1866: , p_data => x_msg_data
1867: );
1868:

Line 2051: OE_MSG_PUB.Count_And_Get

2047: x_return_status := FND_API.G_RET_STS_ERROR;
2048:
2049: -- Get message count and data
2050:
2051: OE_MSG_PUB.Count_And_Get
2052: ( p_count => x_msg_count
2053: , p_data => x_msg_data
2054: );
2055:

Line 2062: OE_MSG_PUB.Count_And_Get

2058: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2059:
2060: -- Get message count and data
2061:
2062: OE_MSG_PUB.Count_And_Get
2063: ( p_count => x_msg_count
2064: , p_data => x_msg_data
2065: );
2066:

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

2067: WHEN OTHERS THEN
2068:
2069: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2070:
2071: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2072: THEN
2073: OE_MSG_PUB.Add_Exc_Msg
2074: ( G_PKG_NAME
2075: , 'Lock_Order'

Line 2073: OE_MSG_PUB.Add_Exc_Msg

2069: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2070:
2071: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2072: THEN
2073: OE_MSG_PUB.Add_Exc_Msg
2074: ( G_PKG_NAME
2075: , 'Lock_Order'
2076: );
2077: END IF;

Line 2081: OE_MSG_PUB.Count_And_Get

2077: END IF;
2078:
2079: -- Get message count and data
2080:
2081: OE_MSG_PUB.Count_And_Get
2082: ( p_count => x_msg_count
2083: , p_data => x_msg_data
2084: );
2085:

Line 2196: OE_MSG_PUB.Count_And_Get

2192: x_return_status := FND_API.G_RET_STS_ERROR;
2193:
2194: -- Get message count and data
2195:
2196: OE_MSG_PUB.Count_And_Get
2197: ( p_count => x_msg_count
2198: , p_data => x_msg_data
2199: );
2200:

Line 2207: OE_MSG_PUB.Count_And_Get

2203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2204:
2205: -- Get message count and data
2206:
2207: OE_MSG_PUB.Count_And_Get
2208: ( p_count => x_msg_count
2209: , p_data => x_msg_data
2210: );
2211:

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

2212: WHEN OTHERS THEN
2213:
2214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2215:
2216: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2217: THEN
2218: OE_MSG_PUB.Add_Exc_Msg
2219: ( G_PKG_NAME
2220: , 'Get_Order'

Line 2218: OE_MSG_PUB.Add_Exc_Msg

2214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2215:
2216: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2217: THEN
2218: OE_MSG_PUB.Add_Exc_Msg
2219: ( G_PKG_NAME
2220: , 'Get_Order'
2221: );
2222: END IF;

Line 2226: OE_MSG_PUB.Count_And_Get

2222: END IF;
2223:
2224: -- Get message count and data
2225:
2226: OE_MSG_PUB.Count_And_Get
2227: ( p_count => x_msg_count
2228: , p_data => x_msg_data
2229: );
2230:

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

2287: EXCEPTION
2288:
2289: WHEN OTHERS THEN
2290:
2291: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2292: THEN
2293: OE_MSG_PUB.Add_Exc_Msg
2294: ( G_PKG_NAME
2295: , 'Id_To_Value'

Line 2293: OE_MSG_PUB.Add_Exc_Msg

2289: WHEN OTHERS THEN
2290:
2291: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2292: THEN
2293: OE_MSG_PUB.Add_Exc_Msg
2294: ( G_PKG_NAME
2295: , 'Id_To_Value'
2296: );
2297: END IF;

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

2377: EXCEPTION
2378:
2379: WHEN OTHERS THEN
2380:
2381: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2382: THEN
2383: OE_MSG_PUB.Add_Exc_Msg
2384: ( G_PKG_NAME
2385: , 'Value_To_Id'

Line 2383: OE_MSG_PUB.Add_Exc_Msg

2379: WHEN OTHERS THEN
2380:
2381: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2382: THEN
2383: OE_MSG_PUB.Add_Exc_Msg
2384: ( G_PKG_NAME
2385: , 'Value_To_Id'
2386: );
2387: END IF;

Line 2444: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

2440: -- ignore p_operating_unit since p_org_id has passed in.
2441: -- We check if both p_org_id and p_operating_unit pass in,
2442: -- add a message just for the information.
2443: IF (p_operating_unit IS NOT NULL AND p_operating_unit <> FND_API.G_MISS_CHAR) THEN
2444: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2445: THEN
2446: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2447: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','operating_unit');
2448: OE_MSG_PUB.Add;

Line 2448: OE_MSG_PUB.Add;

2444: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2445: THEN
2446: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2447: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','operating_unit');
2448: OE_MSG_PUB.Add;
2449: END IF;
2450: END IF;
2451:
2452: ELSE

Line 2538: OE_MSG_PUB.Count_And_Get

2534:
2535: -- Get message count and data
2536:
2537:
2538: OE_MSG_PUB.Count_And_Get
2539: ( p_count => x_msg_count
2540: , p_data => x_msg_data
2541: );
2542:

Line 2548: OE_MSG_PUB.Count_And_Get

2544:
2545: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2546: -- Get message count and data
2547:
2548: OE_MSG_PUB.Count_And_Get
2549: ( p_count => x_msg_count
2550: , p_data => x_msg_data
2551: );
2552:

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

2553: WHEN OTHERS THEN
2554:
2555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2556:
2557: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2558: THEN
2559: OE_MSG_PUB.Add_Exc_Msg
2560: ( G_PKG_NAME
2561: , 'Gen_Gapless_Sequence'

Line 2559: OE_MSG_PUB.Add_Exc_Msg

2555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2556:
2557: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2558: THEN
2559: OE_MSG_PUB.Add_Exc_Msg
2560: ( G_PKG_NAME
2561: , 'Gen_Gapless_Sequence'
2562: );
2563: END IF;

Line 2567: OE_MSG_PUB.Count_And_Get

2563: END IF;
2564:
2565: -- Get message count and data
2566:
2567: OE_MSG_PUB.Count_And_Get
2568: ( p_count => x_msg_count
2569: , p_data => x_msg_data
2570: );
2571:

Line 2624: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

2620: -- ignore p_operating_unit since p_org_id has passed in.
2621: -- We check if both p_org_id and p_operating_unit pass in,
2622: -- add a message just for the information.
2623: IF (p_operating_unit IS NOT NULL AND p_operating_unit <> FND_API.G_MISS_CHAR) THEN
2624: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2625: THEN
2626: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2627: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','operating_unit');
2628: OE_MSG_PUB.Add;

Line 2628: OE_MSG_PUB.Add;

2624: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2625: THEN
2626: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2627: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','operating_unit');
2628: OE_MSG_PUB.Add;
2629: END IF;
2630: END IF;
2631:
2632: ELSE

Line 2720: OE_MSG_PUB.Count_And_Get

2716:
2717: -- Get message count and data
2718:
2719:
2720: OE_MSG_PUB.Count_And_Get
2721: ( p_count => x_msg_count
2722: , p_data => x_msg_data
2723: );
2724:

Line 2730: OE_MSG_PUB.Count_And_Get

2726:
2727: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2728: -- Get message count and data
2729:
2730: OE_MSG_PUB.Count_And_Get
2731: ( p_count => x_msg_count
2732: , p_data => x_msg_data
2733: );
2734:

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

2735: WHEN OTHERS THEN
2736:
2737: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2738:
2739: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2740: THEN
2741: OE_MSG_PUB.Add_Exc_Msg
2742: ( G_PKG_NAME
2743: , 'Gen_Gapless_Sequence'

Line 2741: OE_MSG_PUB.Add_Exc_Msg

2737: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2738:
2739: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2740: THEN
2741: OE_MSG_PUB.Add_Exc_Msg
2742: ( G_PKG_NAME
2743: , 'Gen_Gapless_Sequence'
2744: );
2745: END IF;

Line 2749: OE_MSG_PUB.Count_And_Get

2745: END IF;
2746:
2747: -- Get message count and data
2748:
2749: OE_MSG_PUB.Count_And_Get
2750: ( p_count => x_msg_count
2751: , p_data => x_msg_data
2752: );
2753:

Line 2807: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

2803: -- ignore p_operating_unit since p_org_id has passed in.
2804: -- We check if both p_org_id and p_operating_unit pass in,
2805: -- add a message just for the information.
2806: IF (p_operating_unit IS NOT NULL AND p_operating_unit <> FND_API.G_MISS_CHAR) THEN
2807: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2808: THEN
2809: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2810: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','operating_unit');
2811: OE_MSG_PUB.Add;

Line 2811: OE_MSG_PUB.Add;

2807: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2808: THEN
2809: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2810: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','operating_unit');
2811: OE_MSG_PUB.Add;
2812: END IF;
2813: END IF;
2814:
2815: ELSE

Line 2906: OE_MSG_PUB.Count_And_Get

2902:
2903: -- Get message count and data
2904:
2905:
2906: OE_MSG_PUB.Count_And_Get
2907: ( p_count => x_msg_count
2908: , p_data => x_msg_data
2909: );
2910:

Line 2916: OE_MSG_PUB.Count_And_Get

2912:
2913: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2914: -- Get message count and data
2915:
2916: OE_MSG_PUB.Count_And_Get
2917: ( p_count => x_msg_count
2918: , p_data => x_msg_data
2919: );
2920:

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

2921: WHEN OTHERS THEN
2922:
2923: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2924:
2925: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2926: THEN
2927: OE_MSG_PUB.Add_Exc_Msg
2928: ( G_PKG_NAME
2929: , 'Delete_Order'

Line 2927: OE_MSG_PUB.Add_Exc_Msg

2923: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2924:
2925: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2926: THEN
2927: OE_MSG_PUB.Add_Exc_Msg
2928: ( G_PKG_NAME
2929: , 'Delete_Order'
2930: );
2931: END IF;

Line 2935: OE_MSG_PUB.Count_And_Get

2931: END IF;
2932:
2933: -- Get message count and data
2934:
2935: OE_MSG_PUB.Count_And_Get
2936: ( p_count => x_msg_count
2937: , p_data => x_msg_data
2938: );
2939:

Line 2994: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

2990: -- ignore p_operating_unit since p_org_id has passed in.
2991: -- We check if both p_org_id and p_operating_unit pass in,
2992: -- add a message just for the information.
2993: IF (p_operating_unit IS NOT NULL AND p_operating_unit <> FND_API.G_MISS_CHAR) THEN
2994: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2995: THEN
2996: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2997: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','operating_unit');
2998: OE_MSG_PUB.Add;

Line 2998: OE_MSG_PUB.Add;

2994: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2995: THEN
2996: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2997: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','operating_unit');
2998: OE_MSG_PUB.Add;
2999: END IF;
3000: END IF;
3001:
3002: ELSE

Line 3096: OE_MSG_PUB.Count_And_Get

3092:
3093: -- Get message count and data
3094:
3095:
3096: OE_MSG_PUB.Count_And_Get
3097: ( p_count => x_msg_count
3098: , p_data => x_msg_data
3099: );
3100:

Line 3106: OE_MSG_PUB.Count_And_Get

3102:
3103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3104: -- Get message count and data
3105:
3106: OE_MSG_PUB.Count_And_Get
3107: ( p_count => x_msg_count
3108: , p_data => x_msg_data
3109: );
3110:

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

3111:
3112: WHEN OTHERS THEN
3113:
3114: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3115: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3116: THEN
3117: OE_MSG_PUB.Add_Exc_Msg
3118: ( G_PKG_NAME
3119: , 'Gen_Gapless_Sequence'

Line 3117: OE_MSG_PUB.Add_Exc_Msg

3113:
3114: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3115: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3116: THEN
3117: OE_MSG_PUB.Add_Exc_Msg
3118: ( G_PKG_NAME
3119: , 'Gen_Gapless_Sequence'
3120: );
3121: END IF;

Line 3125: OE_MSG_PUB.Count_And_Get

3121: END IF;
3122:
3123: -- Get message count and data
3124:
3125: OE_MSG_PUB.Count_And_Get
3126: ( p_count => x_msg_count
3127: , p_data => x_msg_data
3128: );
3129:

Line 3186: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

3182: -- ignore p_operating_unit since p_org_id has passed in.
3183: -- We check if both p_org_id and p_operating_unit pass in,
3184: -- add a message just for the information.
3185: IF (p_operating_unit IS NOT NULL AND p_operating_unit <> FND_API.G_MISS_CHAR) THEN
3186: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
3187: THEN
3188: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
3189: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','operating_unit');
3190: OE_MSG_PUB.Add;

Line 3190: OE_MSG_PUB.Add;

3186: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
3187: THEN
3188: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
3189: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','operating_unit');
3190: OE_MSG_PUB.Add;
3191: END IF;
3192: END IF;
3193:
3194: ELSE

Line 3298: OE_MSG_PUB.Count_And_Get

3294:
3295: -- Get message count and data
3296:
3297:
3298: OE_MSG_PUB.Count_And_Get
3299: ( p_count => x_msg_count
3300: , p_data => x_msg_data
3301: );
3302:

Line 3308: OE_MSG_PUB.Count_And_Get

3304:
3305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3306: -- Get message count and data
3307:
3308: OE_MSG_PUB.Count_And_Get
3309: ( p_count => x_msg_count
3310: , p_data => x_msg_data
3311: );
3312:

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

3313: WHEN OTHERS THEN
3314:
3315: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3316:
3317: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3318: THEN
3319: OE_MSG_PUB.Add_Exc_Msg
3320: ( G_PKG_NAME
3321: , 'Update Header'

Line 3319: OE_MSG_PUB.Add_Exc_Msg

3315: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3316:
3317: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3318: THEN
3319: OE_MSG_PUB.Add_Exc_Msg
3320: ( G_PKG_NAME
3321: , 'Update Header'
3322: );
3323: END IF;

Line 3327: OE_MSG_PUB.Count_And_Get

3323: END IF;
3324:
3325: -- Get message count and data
3326:
3327: OE_MSG_PUB.Count_And_Get
3328: ( p_count => x_msg_count
3329: , p_data => x_msg_data
3330: );
3331:

Line 3386: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

3382: -- ignore p_operating_unit since p_org_id has passed in.
3383: -- We check if both p_org_id and p_operating_unit pass in,
3384: -- add a message just for the information.
3385: IF (p_operating_unit IS NOT NULL AND p_operating_unit <> FND_API.G_MISS_CHAR) THEN
3386: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
3387: THEN
3388: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
3389: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','operating_unit');
3390: OE_MSG_PUB.Add;

Line 3390: OE_MSG_PUB.Add;

3386: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
3387: THEN
3388: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
3389: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','operating_unit');
3390: OE_MSG_PUB.Add;
3391: END IF;
3392: END IF;
3393:
3394: ELSE

Line 3497: OE_MSG_PUB.Count_And_Get

3493:
3494: -- Get message count and data
3495:
3496:
3497: OE_MSG_PUB.Count_And_Get
3498: ( p_count => x_msg_count
3499: , p_data => x_msg_data
3500: );
3501:

Line 3507: OE_MSG_PUB.Count_And_Get

3503:
3504: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3505: -- Get message count and data
3506:
3507: OE_MSG_PUB.Count_And_Get
3508: ( p_count => x_msg_count
3509: , p_data => x_msg_data
3510: );
3511:

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

3512:
3513: WHEN OTHERS THEN
3514:
3515: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3516: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3517: THEN
3518: OE_MSG_PUB.Add_Exc_Msg
3519: ( G_PKG_NAME
3520: , 'Update_Line'

Line 3518: OE_MSG_PUB.Add_Exc_Msg

3514:
3515: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3516: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3517: THEN
3518: OE_MSG_PUB.Add_Exc_Msg
3519: ( G_PKG_NAME
3520: , 'Update_Line'
3521: );
3522: END IF;

Line 3526: OE_MSG_PUB.Count_And_Get

3522: END IF;
3523:
3524: -- Get message count and data
3525:
3526: OE_MSG_PUB.Count_And_Get
3527: ( p_count => x_msg_count
3528: , p_data => x_msg_data
3529: );
3530: NULL;

Line 3748: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

3744: -- ignore p_operating_unit since p_org_id has passed in.
3745: -- We check if both p_org_id and p_operating_unit pass in,
3746: -- add a message just for the information.
3747: IF (p_operating_unit IS NOT NULL AND p_operating_unit <> FND_API.G_MISS_CHAR) THEN
3748: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
3749: THEN
3750: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
3751: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','operating_unit');
3752: OE_MSG_PUB.Add;

Line 3752: OE_MSG_PUB.Add;

3748: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
3749: THEN
3750: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
3751: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','operating_unit');
3752: OE_MSG_PUB.Add;
3753: END IF;
3754: END IF;
3755:
3756: ELSE

Line 4031: OE_MSG_PUB.Count_And_Get

4027: x_return_status := FND_API.G_RET_STS_ERROR;
4028:
4029: -- Get message count and data
4030:
4031: OE_MSG_PUB.Count_And_Get
4032: ( p_count => x_msg_count
4033: , p_data => x_msg_data
4034: );
4035:

Line 4042: OE_MSG_PUB.Count_And_Get

4038: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4039:
4040: -- Get message count and data
4041:
4042: OE_MSG_PUB.Count_And_Get
4043: ( p_count => x_msg_count
4044: , p_data => x_msg_data
4045: );
4046:

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

4047: WHEN OTHERS THEN
4048:
4049: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4050:
4051: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4052: THEN
4053: OE_MSG_PUB.Add_Exc_Msg
4054: ( G_PKG_NAME
4055: , 'Process_Order'

Line 4053: OE_MSG_PUB.Add_Exc_Msg

4049: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4050:
4051: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4052: THEN
4053: OE_MSG_PUB.Add_Exc_Msg
4054: ( G_PKG_NAME
4055: , 'Process_Order'
4056: );
4057: END IF;

Line 4061: OE_MSG_PUB.Count_And_Get

4057: END IF;
4058:
4059: -- Get message count and data
4060:
4061: OE_MSG_PUB.Count_And_Get
4062: ( p_count => x_msg_count
4063: , p_data => x_msg_data
4064: );
4065:

Line 4200: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

4196: -- ignore p_operating_unit since p_org_id has passed in.
4197: -- We check if both p_org_id and p_operating_unit pass in,
4198: -- add a message just for the information.
4199: IF (p_operating_unit IS NOT NULL AND p_operating_unit <> FND_API.G_MISS_CHAR) THEN
4200: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4201: THEN
4202: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
4203: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','operating_unit');
4204: OE_MSG_PUB.Add;

Line 4204: OE_MSG_PUB.Add;

4200: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4201: THEN
4202: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
4203: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','operating_unit');
4204: OE_MSG_PUB.Add;
4205: END IF;
4206: END IF;
4207:
4208: ELSE

Line 4368: OE_MSG_PUB.Count_And_Get

4364: x_return_status := FND_API.G_RET_STS_ERROR;
4365:
4366: -- Get message count and data
4367:
4368: OE_MSG_PUB.Count_And_Get
4369: ( p_count => x_msg_count
4370: , p_data => x_msg_data
4371: );
4372:

Line 4379: OE_MSG_PUB.Count_And_Get

4375: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4376:
4377: -- Get message count and data
4378:
4379: OE_MSG_PUB.Count_And_Get
4380: ( p_count => x_msg_count
4381: , p_data => x_msg_data
4382: );
4383:

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

4384: WHEN OTHERS THEN
4385:
4386: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4387:
4388: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4389: THEN
4390: OE_MSG_PUB.Add_Exc_Msg
4391: ( G_PKG_NAME
4392: , 'Lock_Order'

Line 4390: OE_MSG_PUB.Add_Exc_Msg

4386: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4387:
4388: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4389: THEN
4390: OE_MSG_PUB.Add_Exc_Msg
4391: ( G_PKG_NAME
4392: , 'Lock_Order'
4393: );
4394: END IF;

Line 4398: OE_MSG_PUB.Count_And_Get

4394: END IF;
4395:
4396: -- Get message count and data
4397:
4398: OE_MSG_PUB.Count_And_Get
4399: ( p_count => x_msg_count
4400: , p_data => x_msg_data
4401: );
4402:

Line 4479: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

4475: -- ignore p_operating_unit since p_org_id has passed in.
4476: -- We check if both p_org_id and p_operating_unit pass in,
4477: -- add a message just for the information.
4478: IF (p_operating_unit IS NOT NULL AND p_operating_unit <> FND_API.G_MISS_CHAR) THEN
4479: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4480: THEN
4481: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
4482: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','operating_unit');
4483: OE_MSG_PUB.Add;

Line 4483: OE_MSG_PUB.Add;

4479: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4480: THEN
4481: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
4482: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','operating_unit');
4483: OE_MSG_PUB.Add;
4484: END IF;
4485: END IF;
4486:
4487: ELSE

Line 4542: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

4538: ELSIF p_header_id <> FND_API.G_MISS_NUM THEN
4539:
4540: l_header_id := p_header_id;
4541:
4542: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4543: THEN
4544:
4545: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
4546: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','header');

Line 4547: OE_MSG_PUB.Add;

4543: THEN
4544:
4545: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
4546: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','header');
4547: OE_MSG_PUB.Add;
4548:
4549: END IF;
4550:
4551: ELSE

Line 4560: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

4556: ( p_header => p_header
4557: );*/
4558:
4559: IF l_header_id = FND_API.G_MISS_NUM THEN
4560: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4561: THEN
4562:
4563: fnd_message.set_name('ONT','Invalid Business Object Value');
4564: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','header');

Line 4565: OE_MSG_PUB.Add;

4561: THEN
4562:
4563: fnd_message.set_name('ONT','Invalid Business Object Value');
4564: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','header');
4565: OE_MSG_PUB.Add;
4566:
4567: END IF;
4568: END IF;
4569:

Line 4635: OE_MSG_PUB.Count_And_Get

4631: x_return_status := FND_API.G_RET_STS_SUCCESS;
4632:
4633: -- Get message count and data
4634:
4635: OE_MSG_PUB.Count_And_Get
4636: ( p_count => x_msg_count
4637: , p_data => x_msg_data
4638: );
4639:

Line 4649: OE_MSG_PUB.Count_And_Get

4645: x_return_status := FND_API.G_RET_STS_ERROR;
4646:
4647: -- Get message count and data
4648:
4649: OE_MSG_PUB.Count_And_Get
4650: ( p_count => x_msg_count
4651: , p_data => x_msg_data
4652: );
4653:

Line 4660: OE_MSG_PUB.Count_And_Get

4656: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4657:
4658: -- Get message count and data
4659:
4660: OE_MSG_PUB.Count_And_Get
4661: ( p_count => x_msg_count
4662: , p_data => x_msg_data
4663: );
4664:

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

4665: WHEN OTHERS THEN
4666:
4667: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4668:
4669: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4670: THEN
4671: OE_MSG_PUB.Add_Exc_Msg
4672: ( G_PKG_NAME
4673: , 'Get_Order'

Line 4671: OE_MSG_PUB.Add_Exc_Msg

4667: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4668:
4669: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4670: THEN
4671: OE_MSG_PUB.Add_Exc_Msg
4672: ( G_PKG_NAME
4673: , 'Get_Order'
4674: );
4675: END IF;

Line 4679: OE_MSG_PUB.Count_And_Get

4675: END IF;
4676:
4677: -- Get message count and data
4678:
4679: OE_MSG_PUB.Count_And_Get
4680: ( p_count => x_msg_count
4681: , p_data => x_msg_data
4682: );
4683:

Line 4732: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

4728: -- ignore p_operating_unit since p_org_id has passed in.
4729: -- We check if both p_org_id and p_operating_unit pass in,
4730: -- add a message just for the information.
4731: IF (p_operating_unit IS NOT NULL AND p_operating_unit <> FND_API.G_MISS_CHAR) THEN
4732: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4733: THEN
4734: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
4735: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','operating_unit');
4736: OE_MSG_PUB.Add;

Line 4736: OE_MSG_PUB.Add;

4732: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4733: THEN
4734: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
4735: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','operating_unit');
4736: OE_MSG_PUB.Add;
4737: END IF;
4738: END IF;
4739:
4740: ELSE

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

4808: EXCEPTION
4809:
4810: WHEN OTHERS THEN
4811:
4812: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4813: THEN
4814: OE_MSG_PUB.Add_Exc_Msg
4815: ( G_PKG_NAME
4816: , 'Id_To_Value'

Line 4814: OE_MSG_PUB.Add_Exc_Msg

4810: WHEN OTHERS THEN
4811:
4812: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4813: THEN
4814: OE_MSG_PUB.Add_Exc_Msg
4815: ( G_PKG_NAME
4816: , 'Id_To_Value'
4817: );
4818: END IF;

Line 4880: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

4876: -- ignore p_operating_unit since p_org_id has passed in.
4877: -- We check if both p_org_id and p_operating_unit pass in,
4878: -- add a message just for the information.
4879: IF (p_operating_unit IS NOT NULL AND p_operating_unit <> FND_API.G_MISS_CHAR) THEN
4880: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4881: THEN
4882: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
4883: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','operating_unit');
4884: OE_MSG_PUB.Add;

Line 4884: OE_MSG_PUB.Add;

4880: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4881: THEN
4882: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
4883: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','operating_unit');
4884: OE_MSG_PUB.Add;
4885: END IF;
4886: END IF;
4887:
4888: ELSE

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

4970: EXCEPTION
4971:
4972: WHEN OTHERS THEN
4973:
4974: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4975: THEN
4976: OE_MSG_PUB.Add_Exc_Msg
4977: ( G_PKG_NAME
4978: , 'Value_To_Id'

Line 4976: OE_MSG_PUB.Add_Exc_Msg

4972: WHEN OTHERS THEN
4973:
4974: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4975: THEN
4976: OE_MSG_PUB.Add_Exc_Msg
4977: ( G_PKG_NAME
4978: , 'Value_To_Id'
4979: );
4980: END IF;

Line 5026: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

5022: -- ignore p_operating_unit since p_org_id has passed in.
5023: -- We check if both p_org_id and p_operating_unit pass in,
5024: -- add a message just for the information.
5025: IF (p_operating_unit IS NOT NULL AND p_operating_unit <> FND_API.G_MISS_CHAR) THEN
5026: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
5027: THEN
5028: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
5029: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','operating_unit');
5030: OE_MSG_PUB.Add;

Line 5030: OE_MSG_PUB.Add;

5026: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
5027: THEN
5028: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
5029: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','operating_unit');
5030: OE_MSG_PUB.Add;
5031: END IF;
5032: END IF;
5033:
5034: ELSE

Line 5118: OE_MSG_PUB.Count_And_Get

5114: x_return_status := FND_API.G_RET_STS_ERROR;
5115:
5116: -- Get message count and data
5117:
5118: OE_MSG_PUB.Count_And_Get
5119: ( p_count => x_msg_count
5120: , p_data => x_msg_data
5121: );
5122:

Line 5129: OE_MSG_PUB.Count_And_Get

5125: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5126:
5127: -- Get message count and data
5128:
5129: OE_MSG_PUB.Count_And_Get
5130: ( p_count => x_msg_count
5131: , p_data => x_msg_data
5132: );
5133:

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

5134: WHEN OTHERS THEN
5135:
5136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5137:
5138: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5139: THEN
5140: OE_MSG_PUB.Add_Exc_Msg
5141: ( G_PKG_NAME
5142: , 'Process_Order'

Line 5140: OE_MSG_PUB.Add_Exc_Msg

5136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5137:
5138: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5139: THEN
5140: OE_MSG_PUB.Add_Exc_Msg
5141: ( G_PKG_NAME
5142: , 'Process_Order'
5143: );
5144: END IF;

Line 5148: OE_MSG_PUB.Count_And_Get

5144: END IF;
5145:
5146: -- Get message count and data
5147:
5148: OE_MSG_PUB.Count_And_Get
5149: ( p_count => x_msg_count
5150: , p_data => x_msg_data
5151: );
5152: END Process_MACD_Order;