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 1956: OE_MSG_PUB.Count_And_Get

1952: x_return_status := FND_API.G_RET_STS_ERROR;
1953:
1954: -- Get message count and data
1955:
1956: OE_MSG_PUB.Count_And_Get
1957: ( p_count => x_msg_count
1958: , p_data => x_msg_data
1959: );
1960:

Line 1967: OE_MSG_PUB.Count_And_Get

1963: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1964:
1965: -- Get message count and data
1966:
1967: OE_MSG_PUB.Count_And_Get
1968: ( p_count => x_msg_count
1969: , p_data => x_msg_data
1970: );
1971:

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

1972: WHEN OTHERS THEN
1973:
1974: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1975:
1976: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1977: THEN
1978: OE_MSG_PUB.Add_Exc_Msg
1979: ( G_PKG_NAME
1980: , 'Process_Order'

Line 1978: OE_MSG_PUB.Add_Exc_Msg

1974: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1975:
1976: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1977: THEN
1978: OE_MSG_PUB.Add_Exc_Msg
1979: ( G_PKG_NAME
1980: , 'Process_Order'
1981: );
1982: END IF;

Line 1986: OE_MSG_PUB.Count_And_Get

1982: END IF;
1983:
1984: -- Get message count and data
1985:
1986: OE_MSG_PUB.Count_And_Get
1987: ( p_count => x_msg_count
1988: , p_data => x_msg_data
1989: );
1990:

Line 2173: OE_MSG_PUB.Count_And_Get

2169: x_return_status := FND_API.G_RET_STS_ERROR;
2170:
2171: -- Get message count and data
2172:
2173: OE_MSG_PUB.Count_And_Get
2174: ( p_count => x_msg_count
2175: , p_data => x_msg_data
2176: );
2177:

Line 2184: OE_MSG_PUB.Count_And_Get

2180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2181:
2182: -- Get message count and data
2183:
2184: OE_MSG_PUB.Count_And_Get
2185: ( p_count => x_msg_count
2186: , p_data => x_msg_data
2187: );
2188:

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

2189: WHEN OTHERS THEN
2190:
2191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2192:
2193: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2194: THEN
2195: OE_MSG_PUB.Add_Exc_Msg
2196: ( G_PKG_NAME
2197: , 'Lock_Order'

Line 2195: OE_MSG_PUB.Add_Exc_Msg

2191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2192:
2193: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2194: THEN
2195: OE_MSG_PUB.Add_Exc_Msg
2196: ( G_PKG_NAME
2197: , 'Lock_Order'
2198: );
2199: END IF;

Line 2203: OE_MSG_PUB.Count_And_Get

2199: END IF;
2200:
2201: -- Get message count and data
2202:
2203: OE_MSG_PUB.Count_And_Get
2204: ( p_count => x_msg_count
2205: , p_data => x_msg_data
2206: );
2207:

Line 2318: OE_MSG_PUB.Count_And_Get

2314: x_return_status := FND_API.G_RET_STS_ERROR;
2315:
2316: -- Get message count and data
2317:
2318: OE_MSG_PUB.Count_And_Get
2319: ( p_count => x_msg_count
2320: , p_data => x_msg_data
2321: );
2322:

Line 2329: OE_MSG_PUB.Count_And_Get

2325: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2326:
2327: -- Get message count and data
2328:
2329: OE_MSG_PUB.Count_And_Get
2330: ( p_count => x_msg_count
2331: , p_data => x_msg_data
2332: );
2333:

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

2334: WHEN OTHERS THEN
2335:
2336: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2337:
2338: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2339: THEN
2340: OE_MSG_PUB.Add_Exc_Msg
2341: ( G_PKG_NAME
2342: , 'Get_Order'

Line 2340: OE_MSG_PUB.Add_Exc_Msg

2336: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2337:
2338: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2339: THEN
2340: OE_MSG_PUB.Add_Exc_Msg
2341: ( G_PKG_NAME
2342: , 'Get_Order'
2343: );
2344: END IF;

Line 2348: OE_MSG_PUB.Count_And_Get

2344: END IF;
2345:
2346: -- Get message count and data
2347:
2348: OE_MSG_PUB.Count_And_Get
2349: ( p_count => x_msg_count
2350: , p_data => x_msg_data
2351: );
2352:

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

2409: EXCEPTION
2410:
2411: WHEN OTHERS THEN
2412:
2413: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2414: THEN
2415: OE_MSG_PUB.Add_Exc_Msg
2416: ( G_PKG_NAME
2417: , 'Id_To_Value'

Line 2415: OE_MSG_PUB.Add_Exc_Msg

2411: WHEN OTHERS THEN
2412:
2413: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2414: THEN
2415: OE_MSG_PUB.Add_Exc_Msg
2416: ( G_PKG_NAME
2417: , 'Id_To_Value'
2418: );
2419: END IF;

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

2499: EXCEPTION
2500:
2501: WHEN OTHERS THEN
2502:
2503: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2504: THEN
2505: OE_MSG_PUB.Add_Exc_Msg
2506: ( G_PKG_NAME
2507: , 'Value_To_Id'

Line 2505: OE_MSG_PUB.Add_Exc_Msg

2501: WHEN OTHERS THEN
2502:
2503: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2504: THEN
2505: OE_MSG_PUB.Add_Exc_Msg
2506: ( G_PKG_NAME
2507: , 'Value_To_Id'
2508: );
2509: END IF;

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

2562: -- ignore p_operating_unit since p_org_id has passed in.
2563: -- We check if both p_org_id and p_operating_unit pass in,
2564: -- add a message just for the information.
2565: IF (p_operating_unit IS NOT NULL AND p_operating_unit <> FND_API.G_MISS_CHAR) THEN
2566: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2567: THEN
2568: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2569: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','operating_unit');
2570: OE_MSG_PUB.Add;

Line 2570: OE_MSG_PUB.Add;

2566: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2567: THEN
2568: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2569: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','operating_unit');
2570: OE_MSG_PUB.Add;
2571: END IF;
2572: END IF;
2573:
2574: ELSE

Line 2673: OE_MSG_PUB.Count_And_Get

2669:
2670: -- Get message count and data
2671:
2672:
2673: OE_MSG_PUB.Count_And_Get
2674: ( p_count => x_msg_count
2675: , p_data => x_msg_data
2676: );
2677:

Line 2683: OE_MSG_PUB.Count_And_Get

2679:
2680: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2681: -- Get message count and data
2682:
2683: OE_MSG_PUB.Count_And_Get
2684: ( p_count => x_msg_count
2685: , p_data => x_msg_data
2686: );
2687:

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

2688: WHEN OTHERS THEN
2689:
2690: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2691:
2692: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2693: THEN
2694: OE_MSG_PUB.Add_Exc_Msg
2695: ( G_PKG_NAME
2696: , 'Gen_Gapless_Sequence'

Line 2694: OE_MSG_PUB.Add_Exc_Msg

2690: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2691:
2692: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2693: THEN
2694: OE_MSG_PUB.Add_Exc_Msg
2695: ( G_PKG_NAME
2696: , 'Gen_Gapless_Sequence'
2697: );
2698: END IF;

Line 2702: OE_MSG_PUB.Count_And_Get

2698: END IF;
2699:
2700: -- Get message count and data
2701:
2702: OE_MSG_PUB.Count_And_Get
2703: ( p_count => x_msg_count
2704: , p_data => x_msg_data
2705: );
2706:

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

2755: -- ignore p_operating_unit since p_org_id has passed in.
2756: -- We check if both p_org_id and p_operating_unit pass in,
2757: -- add a message just for the information.
2758: IF (p_operating_unit IS NOT NULL AND p_operating_unit <> FND_API.G_MISS_CHAR) THEN
2759: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2760: THEN
2761: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2762: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','operating_unit');
2763: OE_MSG_PUB.Add;

Line 2763: OE_MSG_PUB.Add;

2759: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2760: THEN
2761: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2762: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','operating_unit');
2763: OE_MSG_PUB.Add;
2764: END IF;
2765: END IF;
2766:
2767: ELSE

Line 2855: OE_MSG_PUB.Count_And_Get

2851:
2852: -- Get message count and data
2853:
2854:
2855: OE_MSG_PUB.Count_And_Get
2856: ( p_count => x_msg_count
2857: , p_data => x_msg_data
2858: );
2859:

Line 2865: OE_MSG_PUB.Count_And_Get

2861:
2862: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2863: -- Get message count and data
2864:
2865: OE_MSG_PUB.Count_And_Get
2866: ( p_count => x_msg_count
2867: , p_data => x_msg_data
2868: );
2869:

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

2870: WHEN OTHERS THEN
2871:
2872: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2873:
2874: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2875: THEN
2876: OE_MSG_PUB.Add_Exc_Msg
2877: ( G_PKG_NAME
2878: , 'Gen_Gapless_Sequence'

Line 2876: OE_MSG_PUB.Add_Exc_Msg

2872: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2873:
2874: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2875: THEN
2876: OE_MSG_PUB.Add_Exc_Msg
2877: ( G_PKG_NAME
2878: , 'Gen_Gapless_Sequence'
2879: );
2880: END IF;

Line 2884: OE_MSG_PUB.Count_And_Get

2880: END IF;
2881:
2882: -- Get message count and data
2883:
2884: OE_MSG_PUB.Count_And_Get
2885: ( p_count => x_msg_count
2886: , p_data => x_msg_data
2887: );
2888:

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

2938: -- ignore p_operating_unit since p_org_id has passed in.
2939: -- We check if both p_org_id and p_operating_unit pass in,
2940: -- add a message just for the information.
2941: IF (p_operating_unit IS NOT NULL AND p_operating_unit <> FND_API.G_MISS_CHAR) THEN
2942: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2943: THEN
2944: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2945: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','operating_unit');
2946: OE_MSG_PUB.Add;

Line 2946: OE_MSG_PUB.Add;

2942: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2943: THEN
2944: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2945: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','operating_unit');
2946: OE_MSG_PUB.Add;
2947: END IF;
2948: END IF;
2949:
2950: ELSE

Line 3041: OE_MSG_PUB.Count_And_Get

3037:
3038: -- Get message count and data
3039:
3040:
3041: OE_MSG_PUB.Count_And_Get
3042: ( p_count => x_msg_count
3043: , p_data => x_msg_data
3044: );
3045:

Line 3051: OE_MSG_PUB.Count_And_Get

3047:
3048: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3049: -- Get message count and data
3050:
3051: OE_MSG_PUB.Count_And_Get
3052: ( p_count => x_msg_count
3053: , p_data => x_msg_data
3054: );
3055:

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

3056: WHEN OTHERS THEN
3057:
3058: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3059:
3060: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3061: THEN
3062: OE_MSG_PUB.Add_Exc_Msg
3063: ( G_PKG_NAME
3064: , 'Delete_Order'

Line 3062: OE_MSG_PUB.Add_Exc_Msg

3058: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3059:
3060: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3061: THEN
3062: OE_MSG_PUB.Add_Exc_Msg
3063: ( G_PKG_NAME
3064: , 'Delete_Order'
3065: );
3066: END IF;

Line 3070: OE_MSG_PUB.Count_And_Get

3066: END IF;
3067:
3068: -- Get message count and data
3069:
3070: OE_MSG_PUB.Count_And_Get
3071: ( p_count => x_msg_count
3072: , p_data => x_msg_data
3073: );
3074:

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

3125: -- ignore p_operating_unit since p_org_id has passed in.
3126: -- We check if both p_org_id and p_operating_unit pass in,
3127: -- add a message just for the information.
3128: IF (p_operating_unit IS NOT NULL AND p_operating_unit <> FND_API.G_MISS_CHAR) THEN
3129: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
3130: THEN
3131: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
3132: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','operating_unit');
3133: OE_MSG_PUB.Add;

Line 3133: OE_MSG_PUB.Add;

3129: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
3130: THEN
3131: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
3132: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','operating_unit');
3133: OE_MSG_PUB.Add;
3134: END IF;
3135: END IF;
3136:
3137: ELSE

Line 3231: OE_MSG_PUB.Count_And_Get

3227:
3228: -- Get message count and data
3229:
3230:
3231: OE_MSG_PUB.Count_And_Get
3232: ( p_count => x_msg_count
3233: , p_data => x_msg_data
3234: );
3235:

Line 3241: OE_MSG_PUB.Count_And_Get

3237:
3238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3239: -- Get message count and data
3240:
3241: OE_MSG_PUB.Count_And_Get
3242: ( p_count => x_msg_count
3243: , p_data => x_msg_data
3244: );
3245:

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

3246:
3247: WHEN OTHERS THEN
3248:
3249: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3250: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3251: THEN
3252: OE_MSG_PUB.Add_Exc_Msg
3253: ( G_PKG_NAME
3254: , 'Gen_Gapless_Sequence'

Line 3252: OE_MSG_PUB.Add_Exc_Msg

3248:
3249: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3250: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3251: THEN
3252: OE_MSG_PUB.Add_Exc_Msg
3253: ( G_PKG_NAME
3254: , 'Gen_Gapless_Sequence'
3255: );
3256: END IF;

Line 3260: OE_MSG_PUB.Count_And_Get

3256: END IF;
3257:
3258: -- Get message count and data
3259:
3260: OE_MSG_PUB.Count_And_Get
3261: ( p_count => x_msg_count
3262: , p_data => x_msg_data
3263: );
3264:

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

3317: -- ignore p_operating_unit since p_org_id has passed in.
3318: -- We check if both p_org_id and p_operating_unit pass in,
3319: -- add a message just for the information.
3320: IF (p_operating_unit IS NOT NULL AND p_operating_unit <> FND_API.G_MISS_CHAR) THEN
3321: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
3322: THEN
3323: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
3324: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','operating_unit');
3325: OE_MSG_PUB.Add;

Line 3325: OE_MSG_PUB.Add;

3321: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
3322: THEN
3323: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
3324: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','operating_unit');
3325: OE_MSG_PUB.Add;
3326: END IF;
3327: END IF;
3328:
3329: ELSE

Line 3437: OE_MSG_PUB.Count_And_Get

3433:
3434: -- Get message count and data
3435:
3436:
3437: OE_MSG_PUB.Count_And_Get
3438: ( p_count => x_msg_count
3439: , p_data => x_msg_data
3440: );
3441:

Line 3447: OE_MSG_PUB.Count_And_Get

3443:
3444: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3445: -- Get message count and data
3446:
3447: OE_MSG_PUB.Count_And_Get
3448: ( p_count => x_msg_count
3449: , p_data => x_msg_data
3450: );
3451:

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

3452: WHEN OTHERS THEN
3453:
3454: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3455:
3456: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3457: THEN
3458: OE_MSG_PUB.Add_Exc_Msg
3459: ( G_PKG_NAME
3460: , 'Update Header'

Line 3458: OE_MSG_PUB.Add_Exc_Msg

3454: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3455:
3456: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3457: THEN
3458: OE_MSG_PUB.Add_Exc_Msg
3459: ( G_PKG_NAME
3460: , 'Update Header'
3461: );
3462: END IF;

Line 3466: OE_MSG_PUB.Count_And_Get

3462: END IF;
3463:
3464: -- Get message count and data
3465:
3466: OE_MSG_PUB.Count_And_Get
3467: ( p_count => x_msg_count
3468: , p_data => x_msg_data
3469: );
3470:

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

3521: -- ignore p_operating_unit since p_org_id has passed in.
3522: -- We check if both p_org_id and p_operating_unit pass in,
3523: -- add a message just for the information.
3524: IF (p_operating_unit IS NOT NULL AND p_operating_unit <> FND_API.G_MISS_CHAR) THEN
3525: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
3526: THEN
3527: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
3528: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','operating_unit');
3529: OE_MSG_PUB.Add;

Line 3529: OE_MSG_PUB.Add;

3525: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
3526: THEN
3527: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
3528: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','operating_unit');
3529: OE_MSG_PUB.Add;
3530: END IF;
3531: END IF;
3532:
3533: ELSE

Line 3636: OE_MSG_PUB.Count_And_Get

3632:
3633: -- Get message count and data
3634:
3635:
3636: OE_MSG_PUB.Count_And_Get
3637: ( p_count => x_msg_count
3638: , p_data => x_msg_data
3639: );
3640:

Line 3646: OE_MSG_PUB.Count_And_Get

3642:
3643: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3644: -- Get message count and data
3645:
3646: OE_MSG_PUB.Count_And_Get
3647: ( p_count => x_msg_count
3648: , p_data => x_msg_data
3649: );
3650:

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

3651:
3652: WHEN OTHERS THEN
3653:
3654: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3655: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3656: THEN
3657: OE_MSG_PUB.Add_Exc_Msg
3658: ( G_PKG_NAME
3659: , 'Update_Line'

Line 3657: OE_MSG_PUB.Add_Exc_Msg

3653:
3654: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3655: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3656: THEN
3657: OE_MSG_PUB.Add_Exc_Msg
3658: ( G_PKG_NAME
3659: , 'Update_Line'
3660: );
3661: END IF;

Line 3665: OE_MSG_PUB.Count_And_Get

3661: END IF;
3662:
3663: -- Get message count and data
3664:
3665: OE_MSG_PUB.Count_And_Get
3666: ( p_count => x_msg_count
3667: , p_data => x_msg_data
3668: );
3669: NULL;

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

3889: -- ignore p_operating_unit since p_org_id has passed in.
3890: -- We check if both p_org_id and p_operating_unit pass in,
3891: -- add a message just for the information.
3892: IF (p_operating_unit IS NOT NULL AND p_operating_unit <> FND_API.G_MISS_CHAR) THEN
3893: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
3894: THEN
3895: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
3896: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','operating_unit');
3897: OE_MSG_PUB.Add;

Line 3897: OE_MSG_PUB.Add;

3893: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
3894: THEN
3895: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
3896: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','operating_unit');
3897: OE_MSG_PUB.Add;
3898: END IF;
3899: END IF;
3900:
3901: ELSE

Line 4242: OE_MSG_PUB.Count_And_Get

4238: x_return_status := FND_API.G_RET_STS_ERROR;
4239:
4240: -- Get message count and data
4241:
4242: OE_MSG_PUB.Count_And_Get
4243: ( p_count => x_msg_count
4244: , p_data => x_msg_data
4245: );
4246:

Line 4253: OE_MSG_PUB.Count_And_Get

4249: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4250:
4251: -- Get message count and data
4252:
4253: OE_MSG_PUB.Count_And_Get
4254: ( p_count => x_msg_count
4255: , p_data => x_msg_data
4256: );
4257:

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

4258: WHEN OTHERS THEN
4259:
4260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4261:
4262: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4263: THEN
4264: OE_MSG_PUB.Add_Exc_Msg
4265: ( G_PKG_NAME
4266: , 'Process_Order'

Line 4264: OE_MSG_PUB.Add_Exc_Msg

4260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4261:
4262: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4263: THEN
4264: OE_MSG_PUB.Add_Exc_Msg
4265: ( G_PKG_NAME
4266: , 'Process_Order'
4267: );
4268: END IF;

Line 4272: OE_MSG_PUB.Count_And_Get

4268: END IF;
4269:
4270: -- Get message count and data
4271:
4272: OE_MSG_PUB.Count_And_Get
4273: ( p_count => x_msg_count
4274: , p_data => x_msg_data
4275: );
4276:

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

4407: -- ignore p_operating_unit since p_org_id has passed in.
4408: -- We check if both p_org_id and p_operating_unit pass in,
4409: -- add a message just for the information.
4410: IF (p_operating_unit IS NOT NULL AND p_operating_unit <> FND_API.G_MISS_CHAR) THEN
4411: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4412: THEN
4413: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
4414: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','operating_unit');
4415: OE_MSG_PUB.Add;

Line 4415: OE_MSG_PUB.Add;

4411: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4412: THEN
4413: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
4414: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','operating_unit');
4415: OE_MSG_PUB.Add;
4416: END IF;
4417: END IF;
4418:
4419: ELSE

Line 4579: OE_MSG_PUB.Count_And_Get

4575: x_return_status := FND_API.G_RET_STS_ERROR;
4576:
4577: -- Get message count and data
4578:
4579: OE_MSG_PUB.Count_And_Get
4580: ( p_count => x_msg_count
4581: , p_data => x_msg_data
4582: );
4583:

Line 4590: OE_MSG_PUB.Count_And_Get

4586: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4587:
4588: -- Get message count and data
4589:
4590: OE_MSG_PUB.Count_And_Get
4591: ( p_count => x_msg_count
4592: , p_data => x_msg_data
4593: );
4594:

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

4595: WHEN OTHERS THEN
4596:
4597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4598:
4599: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4600: THEN
4601: OE_MSG_PUB.Add_Exc_Msg
4602: ( G_PKG_NAME
4603: , 'Lock_Order'

Line 4601: OE_MSG_PUB.Add_Exc_Msg

4597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4598:
4599: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4600: THEN
4601: OE_MSG_PUB.Add_Exc_Msg
4602: ( G_PKG_NAME
4603: , 'Lock_Order'
4604: );
4605: END IF;

Line 4609: OE_MSG_PUB.Count_And_Get

4605: END IF;
4606:
4607: -- Get message count and data
4608:
4609: OE_MSG_PUB.Count_And_Get
4610: ( p_count => x_msg_count
4611: , p_data => x_msg_data
4612: );
4613:

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

4686: -- ignore p_operating_unit since p_org_id has passed in.
4687: -- We check if both p_org_id and p_operating_unit pass in,
4688: -- add a message just for the information.
4689: IF (p_operating_unit IS NOT NULL AND p_operating_unit <> FND_API.G_MISS_CHAR) THEN
4690: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4691: THEN
4692: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
4693: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','operating_unit');
4694: OE_MSG_PUB.Add;

Line 4694: OE_MSG_PUB.Add;

4690: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4691: THEN
4692: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
4693: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','operating_unit');
4694: OE_MSG_PUB.Add;
4695: END IF;
4696: END IF;
4697:
4698: ELSE

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

4749: ELSIF p_header_id <> FND_API.G_MISS_NUM THEN
4750:
4751: l_header_id := p_header_id;
4752:
4753: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4754: THEN
4755:
4756: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
4757: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','header');

Line 4758: OE_MSG_PUB.Add;

4754: THEN
4755:
4756: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
4757: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','header');
4758: OE_MSG_PUB.Add;
4759:
4760: END IF;
4761:
4762: ELSE

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

4767: ( p_header => p_header
4768: );*/
4769:
4770: IF l_header_id = FND_API.G_MISS_NUM THEN
4771: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4772: THEN
4773:
4774: fnd_message.set_name('ONT','Invalid Business Object Value');
4775: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','header');

Line 4776: OE_MSG_PUB.Add;

4772: THEN
4773:
4774: fnd_message.set_name('ONT','Invalid Business Object Value');
4775: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','header');
4776: OE_MSG_PUB.Add;
4777:
4778: END IF;
4779: END IF;
4780:

Line 4846: OE_MSG_PUB.Count_And_Get

4842: x_return_status := FND_API.G_RET_STS_SUCCESS;
4843:
4844: -- Get message count and data
4845:
4846: OE_MSG_PUB.Count_And_Get
4847: ( p_count => x_msg_count
4848: , p_data => x_msg_data
4849: );
4850:

Line 4860: OE_MSG_PUB.Count_And_Get

4856: x_return_status := FND_API.G_RET_STS_ERROR;
4857:
4858: -- Get message count and data
4859:
4860: OE_MSG_PUB.Count_And_Get
4861: ( p_count => x_msg_count
4862: , p_data => x_msg_data
4863: );
4864:

Line 4871: OE_MSG_PUB.Count_And_Get

4867: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4868:
4869: -- Get message count and data
4870:
4871: OE_MSG_PUB.Count_And_Get
4872: ( p_count => x_msg_count
4873: , p_data => x_msg_data
4874: );
4875:

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

4876: WHEN OTHERS THEN
4877:
4878: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4879:
4880: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4881: THEN
4882: OE_MSG_PUB.Add_Exc_Msg
4883: ( G_PKG_NAME
4884: , 'Get_Order'

Line 4882: OE_MSG_PUB.Add_Exc_Msg

4878: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4879:
4880: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4881: THEN
4882: OE_MSG_PUB.Add_Exc_Msg
4883: ( G_PKG_NAME
4884: , 'Get_Order'
4885: );
4886: END IF;

Line 4890: OE_MSG_PUB.Count_And_Get

4886: END IF;
4887:
4888: -- Get message count and data
4889:
4890: OE_MSG_PUB.Count_And_Get
4891: ( p_count => x_msg_count
4892: , p_data => x_msg_data
4893: );
4894:

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

4939: -- ignore p_operating_unit since p_org_id has passed in.
4940: -- We check if both p_org_id and p_operating_unit pass in,
4941: -- add a message just for the information.
4942: IF (p_operating_unit IS NOT NULL AND p_operating_unit <> FND_API.G_MISS_CHAR) THEN
4943: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4944: THEN
4945: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
4946: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','operating_unit');
4947: OE_MSG_PUB.Add;

Line 4947: OE_MSG_PUB.Add;

4943: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4944: THEN
4945: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
4946: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','operating_unit');
4947: OE_MSG_PUB.Add;
4948: END IF;
4949: END IF;
4950:
4951: ELSE

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

5019: EXCEPTION
5020:
5021: WHEN OTHERS THEN
5022:
5023: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5024: THEN
5025: OE_MSG_PUB.Add_Exc_Msg
5026: ( G_PKG_NAME
5027: , 'Id_To_Value'

Line 5025: OE_MSG_PUB.Add_Exc_Msg

5021: WHEN OTHERS THEN
5022:
5023: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5024: THEN
5025: OE_MSG_PUB.Add_Exc_Msg
5026: ( G_PKG_NAME
5027: , 'Id_To_Value'
5028: );
5029: END IF;

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

5087: -- ignore p_operating_unit since p_org_id has passed in.
5088: -- We check if both p_org_id and p_operating_unit pass in,
5089: -- add a message just for the information.
5090: IF (p_operating_unit IS NOT NULL AND p_operating_unit <> FND_API.G_MISS_CHAR) THEN
5091: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
5092: THEN
5093: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
5094: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','operating_unit');
5095: OE_MSG_PUB.Add;

Line 5095: OE_MSG_PUB.Add;

5091: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
5092: THEN
5093: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
5094: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','operating_unit');
5095: OE_MSG_PUB.Add;
5096: END IF;
5097: END IF;
5098:
5099: ELSE

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

5181: EXCEPTION
5182:
5183: WHEN OTHERS THEN
5184:
5185: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5186: THEN
5187: OE_MSG_PUB.Add_Exc_Msg
5188: ( G_PKG_NAME
5189: , 'Value_To_Id'

Line 5187: OE_MSG_PUB.Add_Exc_Msg

5183: WHEN OTHERS THEN
5184:
5185: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5186: THEN
5187: OE_MSG_PUB.Add_Exc_Msg
5188: ( G_PKG_NAME
5189: , 'Value_To_Id'
5190: );
5191: END IF;

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

5233: -- ignore p_operating_unit since p_org_id has passed in.
5234: -- We check if both p_org_id and p_operating_unit pass in,
5235: -- add a message just for the information.
5236: IF (p_operating_unit IS NOT NULL AND p_operating_unit <> FND_API.G_MISS_CHAR) THEN
5237: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
5238: THEN
5239: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
5240: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','operating_unit');
5241: OE_MSG_PUB.Add;

Line 5241: OE_MSG_PUB.Add;

5237: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
5238: THEN
5239: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
5240: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','operating_unit');
5241: OE_MSG_PUB.Add;
5242: END IF;
5243: END IF;
5244:
5245: ELSE

Line 5329: OE_MSG_PUB.Count_And_Get

5325: x_return_status := FND_API.G_RET_STS_ERROR;
5326:
5327: -- Get message count and data
5328:
5329: OE_MSG_PUB.Count_And_Get
5330: ( p_count => x_msg_count
5331: , p_data => x_msg_data
5332: );
5333:

Line 5340: OE_MSG_PUB.Count_And_Get

5336: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5337:
5338: -- Get message count and data
5339:
5340: OE_MSG_PUB.Count_And_Get
5341: ( p_count => x_msg_count
5342: , p_data => x_msg_data
5343: );
5344:

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

5345: WHEN OTHERS THEN
5346:
5347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5348:
5349: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5350: THEN
5351: OE_MSG_PUB.Add_Exc_Msg
5352: ( G_PKG_NAME
5353: , 'Process_Order'

Line 5351: OE_MSG_PUB.Add_Exc_Msg

5347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5348:
5349: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5350: THEN
5351: OE_MSG_PUB.Add_Exc_Msg
5352: ( G_PKG_NAME
5353: , 'Process_Order'
5354: );
5355: END IF;

Line 5359: OE_MSG_PUB.Count_And_Get

5355: END IF;
5356:
5357: -- Get message count and data
5358:
5359: OE_MSG_PUB.Count_And_Get
5360: ( p_count => x_msg_count
5361: , p_data => x_msg_data
5362: );
5363: END Process_MACD_Order;