DBA Data[Home] [Help]

APPS.CSP_MATERIAL_TRANSACTIONS_PVT dependencies on STANDARD

Line 37: -- Standard Start of API savepoint

33: l_api_version_number CONSTANT NUMBER := 1.0;
34: l_return_status_full VARCHAR2(1);
35: --l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
36: BEGIN
37: -- Standard Start of API savepoint
38: SAVEPOINT CREATE_MATERIAL_TXN_PVT;
39:
40: -- Standard call to check for call compatibility.
41: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 40: -- Standard call to check for call compatibility.

36: BEGIN
37: -- Standard Start of API savepoint
38: SAVEPOINT CREATE_MATERIAL_TXN_PVT;
39:
40: -- Standard call to check for call compatibility.
41: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
42: p_api_version_number,
43: l_api_name,
44: G_PKG_NAME)

Line 329: p_STANDARD_OPERATION_ID => p_CSP_rec.STANDARD_OPERATION_ID,

325: p_TASK_GROUP_ID => p_CSP_rec.TASK_GROUP_ID,
326: p_PICK_SLIP_NUMBER => p_CSP_rec.PICK_SLIP_NUMBER,
327: p_RESERVATION_ID => p_CSP_rec.RESERVATION_ID,
328: p_TRANSACTION_STATUS => p_CSP_rec.TRANSACTION_STATUS,
329: p_STANDARD_OPERATION_ID => p_CSP_rec.STANDARD_OPERATION_ID,
330: p_TASK_PRIORITY => p_CSP_rec.TASK_PRIORITY,
331: p_WMS_TASK_TYPE => p_CSP_rec.WMS_TASK_TYPE,
332: p_PARENT_LINE_ID => p_CSP_rec.PARENT_LINE_ID);
333: -- P_SOURCE_LOT_NUMBER => p_CSP_rec.SOURCE_LOT_NUMBER);

Line 345: -- Standard check for p_commit

341: --
342: -- End of API body
343: --
344:
345: -- Standard check for p_commit
346: IF FND_API.to_Boolean( p_commit )
347: THEN
348: COMMIT WORK;
349: END IF;

Line 356: -- Standard call to get message count and if count is 1, get message info.

352: -- Debug Message
353: -- JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
354:
355:
356: -- Standard call to get message count and if count is 1, get message info.
357: FND_MSG_PUB.Count_And_Get
358: ( p_count => x_msg_count,
359: p_data => x_msg_data
360: );

Line 626: -- Standard Start of API savepoint

622: l_ref_CSP_rec CSP_material_transactions_PVT.CSP_Rec_Type;
623: l_tar_CSP_rec CSP_material_transactions_PVT.CSP_Rec_Type := P_CSP_Rec;
624: l_rowid ROWID;
625: BEGIN
626: -- Standard Start of API savepoint
627: SAVEPOINT UPDATE_MATERIAL_TXN_PVT;
628:
629: -- Standard call to check for call compatibility.
630: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 629: -- Standard call to check for call compatibility.

625: BEGIN
626: -- Standard Start of API savepoint
627: SAVEPOINT UPDATE_MATERIAL_TXN_PVT;
628:
629: -- Standard call to check for call compatibility.
630: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
631: p_api_version_number,
632: l_api_name,
633: G_PKG_NAME)

Line 1132: p_STANDARD_OPERATION_ID => p_CSP_rec.STANDARD_OPERATION_ID,

1128: p_TASK_GROUP_ID => p_CSP_rec.TASK_GROUP_ID,
1129: p_PICK_SLIP_NUMBER => p_CSP_rec.PICK_SLIP_NUMBER,
1130: p_RESERVATION_ID => p_CSP_rec.RESERVATION_ID,
1131: p_TRANSACTION_STATUS => p_CSP_rec.TRANSACTION_STATUS,
1132: p_STANDARD_OPERATION_ID => p_CSP_rec.STANDARD_OPERATION_ID,
1133: p_TASK_PRIORITY => p_CSP_rec.TASK_PRIORITY,
1134: p_WMS_TASK_TYPE => p_CSP_rec.WMS_TASK_TYPE,
1135: p_PARENT_LINE_ID => p_CSP_rec.PARENT_LINE_ID);
1136: -- P_SOURCE_LOT_NUMBER => p_CSP_rec.SOURCE_LOT_NUMBER);

Line 1141: -- Standard check for p_commit

1137: --
1138: -- End of API body.
1139: --
1140:
1141: -- Standard check for p_commit
1142: IF FND_API.to_Boolean( p_commit )
1143: THEN
1144: COMMIT WORK;
1145: END IF;

Line 1152: -- Standard call to get message count and if count is 1, get message info.

1148: -- Debug Message
1149: --JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
1150:
1151:
1152: -- Standard call to get message count and if count is 1, get message info.
1153: FND_MSG_PUB.Count_And_Get
1154: ( p_count => x_msg_count,
1155: p_data => x_msg_data
1156: );

Line 1230: -- Standard Start of API savepoint

1226: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
1227: BEGIN
1228: --dbms_output.put_line('START CSP_MATERIAL');
1229:
1230: -- Standard Start of API savepoint
1231: SAVEPOINT DELETE_MATERIAL_TXN_PVT;
1232:
1233: -- Standard call to check for call compatibility.
1234: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 1233: -- Standard call to check for call compatibility.

1229:
1230: -- Standard Start of API savepoint
1231: SAVEPOINT DELETE_MATERIAL_TXN_PVT;
1232:
1233: -- Standard call to check for call compatibility.
1234: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1235: p_api_version_number,
1236: l_api_name,
1237: G_PKG_NAME)

Line 1300: -- Standard check for p_commit

1296:
1297: CSP_MTL_TRANSACTIONS_PKG.Delete_Row(
1298: p_TRANSACTION_TEMP_ID => p_CSP_rec.TRANSACTION_TEMP_ID);
1299:
1300: -- Standard check for p_commit
1301: IF FND_API.to_Boolean( p_commit )
1302: THEN
1303: COMMIT WORK;
1304: END IF;

Line 1311: -- Standard call to get message count and if count is 1, get message info.

1307: -- Debug Message
1308: -- JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
1309:
1310:
1311: -- Standard call to get message count and if count is 1, get message info.
1312: FND_MSG_PUB.Count_And_Get
1313: ( p_count => x_msg_count,
1314: p_data => x_msg_data
1315: );

Line 2172: -- Standard call to get message count and if count is 1, get message info.

2168: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2169: NULL;
2170: END IF;
2171:
2172: -- Standard call to get message count and if count is 1, get message info.
2173: FND_MSG_PUB.Count_And_Get
2174: ( p_count => x_msg_count,
2175: p_data => x_msg_data
2176: );

Line 2219: -- Standard call to get message count and if count is 1, get message info.

2215: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2216: NULL;
2217: END IF;
2218:
2219: -- Standard call to get message count and if count is 1, get message info.
2220: FND_MSG_PUB.Count_And_Get
2221: ( p_count => x_msg_count,
2222: p_data => x_msg_data
2223: );

Line 2266: -- Standard call to get message count and if count is 1, get message info.

2262: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2263: NULL;
2264: END IF;
2265:
2266: -- Standard call to get message count and if count is 1, get message info.
2267: FND_MSG_PUB.Count_And_Get
2268: ( p_count => x_msg_count,
2269: p_data => x_msg_data
2270: );

Line 2313: -- Standard call to get message count and if count is 1, get message info.

2309: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2310: NULL;
2311: END IF;
2312:
2313: -- Standard call to get message count and if count is 1, get message info.
2314: FND_MSG_PUB.Count_And_Get
2315: ( p_count => x_msg_count,
2316: p_data => x_msg_data
2317: );

Line 2360: -- Standard call to get message count and if count is 1, get message info.

2356: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2357: NULL;
2358: END IF;
2359:
2360: -- Standard call to get message count and if count is 1, get message info.
2361: FND_MSG_PUB.Count_And_Get
2362: ( p_count => x_msg_count,
2363: p_data => x_msg_data
2364: );

Line 2407: -- Standard call to get message count and if count is 1, get message info.

2403: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2404: NULL;
2405: END IF;
2406:
2407: -- Standard call to get message count and if count is 1, get message info.
2408: FND_MSG_PUB.Count_And_Get
2409: ( p_count => x_msg_count,
2410: p_data => x_msg_data
2411: );

Line 2454: -- Standard call to get message count and if count is 1, get message info.

2450: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2451: NULL;
2452: END IF;
2453:
2454: -- Standard call to get message count and if count is 1, get message info.
2455: FND_MSG_PUB.Count_And_Get
2456: ( p_count => x_msg_count,
2457: p_data => x_msg_data
2458: );

Line 2508: -- Standard call to get message count and if count is 1, get message info.

2504: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2505: NULL;
2506: END IF;
2507:
2508: -- Standard call to get message count and if count is 1, get message info.
2509: FND_MSG_PUB.Count_And_Get
2510: ( p_count => x_msg_count,
2511: p_data => x_msg_data
2512: );

Line 2555: -- Standard call to get message count and if count is 1, get message info.

2551: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2552: NULL;
2553: END IF;
2554:
2555: -- Standard call to get message count and if count is 1, get message info.
2556: FND_MSG_PUB.Count_And_Get
2557: ( p_count => x_msg_count,
2558: p_data => x_msg_data
2559: );

Line 2609: -- Standard call to get message count and if count is 1, get message info.

2605: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2606: NULL;
2607: END IF;
2608:
2609: -- Standard call to get message count and if count is 1, get message info.
2610: FND_MSG_PUB.Count_And_Get
2611: ( p_count => x_msg_count,
2612: p_data => x_msg_data
2613: );

Line 2656: -- Standard call to get message count and if count is 1, get message info.

2652: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2653: NULL;
2654: END IF;
2655:
2656: -- Standard call to get message count and if count is 1, get message info.
2657: FND_MSG_PUB.Count_And_Get
2658: ( p_count => x_msg_count,
2659: p_data => x_msg_data
2660: );

Line 2703: -- Standard call to get message count and if count is 1, get message info.

2699: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2700: NULL;
2701: END IF;
2702:
2703: -- Standard call to get message count and if count is 1, get message info.
2704: FND_MSG_PUB.Count_And_Get
2705: ( p_count => x_msg_count,
2706: p_data => x_msg_data
2707: );

Line 2757: -- Standard call to get message count and if count is 1, get message info.

2753: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2754: NULL;
2755: END IF;
2756:
2757: -- Standard call to get message count and if count is 1, get message info.
2758: FND_MSG_PUB.Count_And_Get
2759: ( p_count => x_msg_count,
2760: p_data => x_msg_data
2761: );

Line 2811: -- Standard call to get message count and if count is 1, get message info.

2807: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2808: NULL;
2809: END IF;
2810:
2811: -- Standard call to get message count and if count is 1, get message info.
2812: FND_MSG_PUB.Count_And_Get
2813: ( p_count => x_msg_count,
2814: p_data => x_msg_data
2815: );

Line 2865: -- Standard call to get message count and if count is 1, get message info.

2861: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2862: NULL;
2863: END IF;
2864:
2865: -- Standard call to get message count and if count is 1, get message info.
2866: FND_MSG_PUB.Count_And_Get
2867: ( p_count => x_msg_count,
2868: p_data => x_msg_data
2869: );

Line 2912: -- Standard call to get message count and if count is 1, get message info.

2908: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2909: NULL;
2910: END IF;
2911:
2912: -- Standard call to get message count and if count is 1, get message info.
2913: FND_MSG_PUB.Count_And_Get
2914: ( p_count => x_msg_count,
2915: p_data => x_msg_data
2916: );

Line 2966: -- Standard call to get message count and if count is 1, get message info.

2962: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
2963: NULL;
2964: END IF;
2965:
2966: -- Standard call to get message count and if count is 1, get message info.
2967: FND_MSG_PUB.Count_And_Get
2968: ( p_count => x_msg_count,
2969: p_data => x_msg_data
2970: );

Line 3020: -- Standard call to get message count and if count is 1, get message info.

3016: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
3017: NULL;
3018: END IF;
3019:
3020: -- Standard call to get message count and if count is 1, get message info.
3021: FND_MSG_PUB.Count_And_Get
3022: ( p_count => x_msg_count,
3023: p_data => x_msg_data
3024: );

Line 3074: -- Standard call to get message count and if count is 1, get message info.

3070: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
3071: NULL;
3072: END IF;
3073:
3074: -- Standard call to get message count and if count is 1, get message info.
3075: FND_MSG_PUB.Count_And_Get
3076: ( p_count => x_msg_count,
3077: p_data => x_msg_data
3078: );

Line 3121: -- Standard call to get message count and if count is 1, get message info.

3117: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
3118: NULL;
3119: END IF;
3120:
3121: -- Standard call to get message count and if count is 1, get message info.
3122: FND_MSG_PUB.Count_And_Get
3123: ( p_count => x_msg_count,
3124: p_data => x_msg_data
3125: );

Line 3168: -- Standard call to get message count and if count is 1, get message info.

3164: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
3165: NULL;
3166: END IF;
3167:
3168: -- Standard call to get message count and if count is 1, get message info.
3169: FND_MSG_PUB.Count_And_Get
3170: ( p_count => x_msg_count,
3171: p_data => x_msg_data
3172: );

Line 3222: -- Standard call to get message count and if count is 1, get message info.

3218: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
3219: NULL;
3220: END IF;
3221:
3222: -- Standard call to get message count and if count is 1, get message info.
3223: FND_MSG_PUB.Count_And_Get
3224: ( p_count => x_msg_count,
3225: p_data => x_msg_data
3226: );

Line 3276: -- Standard call to get message count and if count is 1, get message info.

3272: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
3273: NULL;
3274: END IF;
3275:
3276: -- Standard call to get message count and if count is 1, get message info.
3277: FND_MSG_PUB.Count_And_Get
3278: ( p_count => x_msg_count,
3279: p_data => x_msg_data
3280: );

Line 3323: -- Standard call to get message count and if count is 1, get message info.

3319: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
3320: NULL;
3321: END IF;
3322:
3323: -- Standard call to get message count and if count is 1, get message info.
3324: FND_MSG_PUB.Count_And_Get
3325: ( p_count => x_msg_count,
3326: p_data => x_msg_data
3327: );

Line 3370: -- Standard call to get message count and if count is 1, get message info.

3366: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
3367: NULL;
3368: END IF;
3369:
3370: -- Standard call to get message count and if count is 1, get message info.
3371: FND_MSG_PUB.Count_And_Get
3372: ( p_count => x_msg_count,
3373: p_data => x_msg_data
3374: );

Line 3417: -- Standard call to get message count and if count is 1, get message info.

3413: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
3414: NULL;
3415: END IF;
3416:
3417: -- Standard call to get message count and if count is 1, get message info.
3418: FND_MSG_PUB.Count_And_Get
3419: ( p_count => x_msg_count,
3420: p_data => x_msg_data
3421: );

Line 3464: -- Standard call to get message count and if count is 1, get message info.

3460: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
3461: NULL;
3462: END IF;
3463:
3464: -- Standard call to get message count and if count is 1, get message info.
3465: FND_MSG_PUB.Count_And_Get
3466: ( p_count => x_msg_count,
3467: p_data => x_msg_data
3468: );

Line 3511: -- Standard call to get message count and if count is 1, get message info.

3507: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
3508: NULL;
3509: END IF;
3510:
3511: -- Standard call to get message count and if count is 1, get message info.
3512: FND_MSG_PUB.Count_And_Get
3513: ( p_count => x_msg_count,
3514: p_data => x_msg_data
3515: );

Line 3558: -- Standard call to get message count and if count is 1, get message info.

3554: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
3555: NULL;
3556: END IF;
3557:
3558: -- Standard call to get message count and if count is 1, get message info.
3559: FND_MSG_PUB.Count_And_Get
3560: ( p_count => x_msg_count,
3561: p_data => x_msg_data
3562: );

Line 3605: -- Standard call to get message count and if count is 1, get message info.

3601: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
3602: NULL;
3603: END IF;
3604:
3605: -- Standard call to get message count and if count is 1, get message info.
3606: FND_MSG_PUB.Count_And_Get
3607: ( p_count => x_msg_count,
3608: p_data => x_msg_data
3609: );

Line 3652: -- Standard call to get message count and if count is 1, get message info.

3648: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
3649: NULL;
3650: END IF;
3651:
3652: -- Standard call to get message count and if count is 1, get message info.
3653: FND_MSG_PUB.Count_And_Get
3654: ( p_count => x_msg_count,
3655: p_data => x_msg_data
3656: );

Line 3699: -- Standard call to get message count and if count is 1, get message info.

3695: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
3696: NULL;
3697: END IF;
3698:
3699: -- Standard call to get message count and if count is 1, get message info.
3700: FND_MSG_PUB.Count_And_Get
3701: ( p_count => x_msg_count,
3702: p_data => x_msg_data
3703: );

Line 3746: -- Standard call to get message count and if count is 1, get message info.

3742: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
3743: NULL;
3744: END IF;
3745:
3746: -- Standard call to get message count and if count is 1, get message info.
3747: FND_MSG_PUB.Count_And_Get
3748: ( p_count => x_msg_count,
3749: p_data => x_msg_data
3750: );

Line 3793: -- Standard call to get message count and if count is 1, get message info.

3789: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
3790: NULL;
3791: END IF;
3792:
3793: -- Standard call to get message count and if count is 1, get message info.
3794: FND_MSG_PUB.Count_And_Get
3795: ( p_count => x_msg_count,
3796: p_data => x_msg_data
3797: );

Line 3840: -- Standard call to get message count and if count is 1, get message info.

3836: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
3837: NULL;
3838: END IF;
3839:
3840: -- Standard call to get message count and if count is 1, get message info.
3841: FND_MSG_PUB.Count_And_Get
3842: ( p_count => x_msg_count,
3843: p_data => x_msg_data
3844: );

Line 3887: -- Standard call to get message count and if count is 1, get message info.

3883: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
3884: NULL;
3885: END IF;
3886:
3887: -- Standard call to get message count and if count is 1, get message info.
3888: FND_MSG_PUB.Count_And_Get
3889: ( p_count => x_msg_count,
3890: p_data => x_msg_data
3891: );

Line 3934: -- Standard call to get message count and if count is 1, get message info.

3930: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
3931: NULL;
3932: END IF;
3933:
3934: -- Standard call to get message count and if count is 1, get message info.
3935: FND_MSG_PUB.Count_And_Get
3936: ( p_count => x_msg_count,
3937: p_data => x_msg_data
3938: );

Line 3981: -- Standard call to get message count and if count is 1, get message info.

3977: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
3978: NULL;
3979: END IF;
3980:
3981: -- Standard call to get message count and if count is 1, get message info.
3982: FND_MSG_PUB.Count_And_Get
3983: ( p_count => x_msg_count,
3984: p_data => x_msg_data
3985: );

Line 4028: -- Standard call to get message count and if count is 1, get message info.

4024: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
4025: NULL;
4026: END IF;
4027:
4028: -- Standard call to get message count and if count is 1, get message info.
4029: FND_MSG_PUB.Count_And_Get
4030: ( p_count => x_msg_count,
4031: p_data => x_msg_data
4032: );

Line 4075: -- Standard call to get message count and if count is 1, get message info.

4071: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
4072: NULL;
4073: END IF;
4074:
4075: -- Standard call to get message count and if count is 1, get message info.
4076: FND_MSG_PUB.Count_And_Get
4077: ( p_count => x_msg_count,
4078: p_data => x_msg_data
4079: );

Line 4122: -- Standard call to get message count and if count is 1, get message info.

4118: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
4119: NULL;
4120: END IF;
4121:
4122: -- Standard call to get message count and if count is 1, get message info.
4123: FND_MSG_PUB.Count_And_Get
4124: ( p_count => x_msg_count,
4125: p_data => x_msg_data
4126: );

Line 4169: -- Standard call to get message count and if count is 1, get message info.

4165: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
4166: NULL;
4167: END IF;
4168:
4169: -- Standard call to get message count and if count is 1, get message info.
4170: FND_MSG_PUB.Count_And_Get
4171: ( p_count => x_msg_count,
4172: p_data => x_msg_data
4173: );

Line 4216: -- Standard call to get message count and if count is 1, get message info.

4212: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
4213: NULL;
4214: END IF;
4215:
4216: -- Standard call to get message count and if count is 1, get message info.
4217: FND_MSG_PUB.Count_And_Get
4218: ( p_count => x_msg_count,
4219: p_data => x_msg_data
4220: );

Line 4263: -- Standard call to get message count and if count is 1, get message info.

4259: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
4260: NULL;
4261: END IF;
4262:
4263: -- Standard call to get message count and if count is 1, get message info.
4264: FND_MSG_PUB.Count_And_Get
4265: ( p_count => x_msg_count,
4266: p_data => x_msg_data
4267: );

Line 4310: -- Standard call to get message count and if count is 1, get message info.

4306: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
4307: NULL;
4308: END IF;
4309:
4310: -- Standard call to get message count and if count is 1, get message info.
4311: FND_MSG_PUB.Count_And_Get
4312: ( p_count => x_msg_count,
4313: p_data => x_msg_data
4314: );

Line 4357: -- Standard call to get message count and if count is 1, get message info.

4353: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
4354: NULL;
4355: END IF;
4356:
4357: -- Standard call to get message count and if count is 1, get message info.
4358: FND_MSG_PUB.Count_And_Get
4359: ( p_count => x_msg_count,
4360: p_data => x_msg_data
4361: );

Line 4404: -- Standard call to get message count and if count is 1, get message info.

4400: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
4401: NULL;
4402: END IF;
4403:
4404: -- Standard call to get message count and if count is 1, get message info.
4405: FND_MSG_PUB.Count_And_Get
4406: ( p_count => x_msg_count,
4407: p_data => x_msg_data
4408: );

Line 4451: -- Standard call to get message count and if count is 1, get message info.

4447: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
4448: NULL;
4449: END IF;
4450:
4451: -- Standard call to get message count and if count is 1, get message info.
4452: FND_MSG_PUB.Count_And_Get
4453: ( p_count => x_msg_count,
4454: p_data => x_msg_data
4455: );

Line 4498: -- Standard call to get message count and if count is 1, get message info.

4494: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
4495: NULL;
4496: END IF;
4497:
4498: -- Standard call to get message count and if count is 1, get message info.
4499: FND_MSG_PUB.Count_And_Get
4500: ( p_count => x_msg_count,
4501: p_data => x_msg_data
4502: );

Line 4545: -- Standard call to get message count and if count is 1, get message info.

4541: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
4542: NULL;
4543: END IF;
4544:
4545: -- Standard call to get message count and if count is 1, get message info.
4546: FND_MSG_PUB.Count_And_Get
4547: ( p_count => x_msg_count,
4548: p_data => x_msg_data
4549: );

Line 4592: -- Standard call to get message count and if count is 1, get message info.

4588: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
4589: NULL;
4590: END IF;
4591:
4592: -- Standard call to get message count and if count is 1, get message info.
4593: FND_MSG_PUB.Count_And_Get
4594: ( p_count => x_msg_count,
4595: p_data => x_msg_data
4596: );

Line 4639: -- Standard call to get message count and if count is 1, get message info.

4635: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
4636: NULL;
4637: END IF;
4638:
4639: -- Standard call to get message count and if count is 1, get message info.
4640: FND_MSG_PUB.Count_And_Get
4641: ( p_count => x_msg_count,
4642: p_data => x_msg_data
4643: );

Line 4686: -- Standard call to get message count and if count is 1, get message info.

4682: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
4683: NULL;
4684: END IF;
4685:
4686: -- Standard call to get message count and if count is 1, get message info.
4687: FND_MSG_PUB.Count_And_Get
4688: ( p_count => x_msg_count,
4689: p_data => x_msg_data
4690: );

Line 4733: -- Standard call to get message count and if count is 1, get message info.

4729: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
4730: NULL;
4731: END IF;
4732:
4733: -- Standard call to get message count and if count is 1, get message info.
4734: FND_MSG_PUB.Count_And_Get
4735: ( p_count => x_msg_count,
4736: p_data => x_msg_data
4737: );

Line 4780: -- Standard call to get message count and if count is 1, get message info.

4776: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
4777: NULL;
4778: END IF;
4779:
4780: -- Standard call to get message count and if count is 1, get message info.
4781: FND_MSG_PUB.Count_And_Get
4782: ( p_count => x_msg_count,
4783: p_data => x_msg_data
4784: );

Line 4827: -- Standard call to get message count and if count is 1, get message info.

4823: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
4824: NULL;
4825: END IF;
4826:
4827: -- Standard call to get message count and if count is 1, get message info.
4828: FND_MSG_PUB.Count_And_Get
4829: ( p_count => x_msg_count,
4830: p_data => x_msg_data
4831: );

Line 4874: -- Standard call to get message count and if count is 1, get message info.

4870: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
4871: NULL;
4872: END IF;
4873:
4874: -- Standard call to get message count and if count is 1, get message info.
4875: FND_MSG_PUB.Count_And_Get
4876: ( p_count => x_msg_count,
4877: p_data => x_msg_data
4878: );

Line 4921: -- Standard call to get message count and if count is 1, get message info.

4917: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
4918: NULL;
4919: END IF;
4920:
4921: -- Standard call to get message count and if count is 1, get message info.
4922: FND_MSG_PUB.Count_And_Get
4923: ( p_count => x_msg_count,
4924: p_data => x_msg_data
4925: );

Line 4968: -- Standard call to get message count and if count is 1, get message info.

4964: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
4965: NULL;
4966: END IF;
4967:
4968: -- Standard call to get message count and if count is 1, get message info.
4969: FND_MSG_PUB.Count_And_Get
4970: ( p_count => x_msg_count,
4971: p_data => x_msg_data
4972: );

Line 5015: -- Standard call to get message count and if count is 1, get message info.

5011: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
5012: NULL;
5013: END IF;
5014:
5015: -- Standard call to get message count and if count is 1, get message info.
5016: FND_MSG_PUB.Count_And_Get
5017: ( p_count => x_msg_count,
5018: p_data => x_msg_data
5019: );

Line 5062: -- Standard call to get message count and if count is 1, get message info.

5058: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
5059: NULL;
5060: END IF;
5061:
5062: -- Standard call to get message count and if count is 1, get message info.
5063: FND_MSG_PUB.Count_And_Get
5064: ( p_count => x_msg_count,
5065: p_data => x_msg_data
5066: );

Line 5109: -- Standard call to get message count and if count is 1, get message info.

5105: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
5106: NULL;
5107: END IF;
5108:
5109: -- Standard call to get message count and if count is 1, get message info.
5110: FND_MSG_PUB.Count_And_Get
5111: ( p_count => x_msg_count,
5112: p_data => x_msg_data
5113: );

Line 5156: -- Standard call to get message count and if count is 1, get message info.

5152: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
5153: NULL;
5154: END IF;
5155:
5156: -- Standard call to get message count and if count is 1, get message info.
5157: FND_MSG_PUB.Count_And_Get
5158: ( p_count => x_msg_count,
5159: p_data => x_msg_data
5160: );

Line 5203: -- Standard call to get message count and if count is 1, get message info.

5199: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
5200: NULL;
5201: END IF;
5202:
5203: -- Standard call to get message count and if count is 1, get message info.
5204: FND_MSG_PUB.Count_And_Get
5205: ( p_count => x_msg_count,
5206: p_data => x_msg_data
5207: );

Line 5250: -- Standard call to get message count and if count is 1, get message info.

5246: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
5247: NULL;
5248: END IF;
5249:
5250: -- Standard call to get message count and if count is 1, get message info.
5251: FND_MSG_PUB.Count_And_Get
5252: ( p_count => x_msg_count,
5253: p_data => x_msg_data
5254: );

Line 5297: -- Standard call to get message count and if count is 1, get message info.

5293: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
5294: NULL;
5295: END IF;
5296:
5297: -- Standard call to get message count and if count is 1, get message info.
5298: FND_MSG_PUB.Count_And_Get
5299: ( p_count => x_msg_count,
5300: p_data => x_msg_data
5301: );

Line 5344: -- Standard call to get message count and if count is 1, get message info.

5340: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
5341: NULL;
5342: END IF;
5343:
5344: -- Standard call to get message count and if count is 1, get message info.
5345: FND_MSG_PUB.Count_And_Get
5346: ( p_count => x_msg_count,
5347: p_data => x_msg_data
5348: );

Line 5391: -- Standard call to get message count and if count is 1, get message info.

5387: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
5388: NULL;
5389: END IF;
5390:
5391: -- Standard call to get message count and if count is 1, get message info.
5392: FND_MSG_PUB.Count_And_Get
5393: ( p_count => x_msg_count,
5394: p_data => x_msg_data
5395: );

Line 5438: -- Standard call to get message count and if count is 1, get message info.

5434: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
5435: NULL;
5436: END IF;
5437:
5438: -- Standard call to get message count and if count is 1, get message info.
5439: FND_MSG_PUB.Count_And_Get
5440: ( p_count => x_msg_count,
5441: p_data => x_msg_data
5442: );

Line 5485: -- Standard call to get message count and if count is 1, get message info.

5481: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
5482: NULL;
5483: END IF;
5484:
5485: -- Standard call to get message count and if count is 1, get message info.
5486: FND_MSG_PUB.Count_And_Get
5487: ( p_count => x_msg_count,
5488: p_data => x_msg_data
5489: );

Line 5532: -- Standard call to get message count and if count is 1, get message info.

5528: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
5529: NULL;
5530: END IF;
5531:
5532: -- Standard call to get message count and if count is 1, get message info.
5533: FND_MSG_PUB.Count_And_Get
5534: ( p_count => x_msg_count,
5535: p_data => x_msg_data
5536: );

Line 5579: -- Standard call to get message count and if count is 1, get message info.

5575: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
5576: NULL;
5577: END IF;
5578:
5579: -- Standard call to get message count and if count is 1, get message info.
5580: FND_MSG_PUB.Count_And_Get
5581: ( p_count => x_msg_count,
5582: p_data => x_msg_data
5583: );

Line 5626: -- Standard call to get message count and if count is 1, get message info.

5622: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
5623: NULL;
5624: END IF;
5625:
5626: -- Standard call to get message count and if count is 1, get message info.
5627: FND_MSG_PUB.Count_And_Get
5628: ( p_count => x_msg_count,
5629: p_data => x_msg_data
5630: );

Line 5673: -- Standard call to get message count and if count is 1, get message info.

5669: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
5670: NULL;
5671: END IF;
5672:
5673: -- Standard call to get message count and if count is 1, get message info.
5674: FND_MSG_PUB.Count_And_Get
5675: ( p_count => x_msg_count,
5676: p_data => x_msg_data
5677: );

Line 5720: -- Standard call to get message count and if count is 1, get message info.

5716: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
5717: NULL;
5718: END IF;
5719:
5720: -- Standard call to get message count and if count is 1, get message info.
5721: FND_MSG_PUB.Count_And_Get
5722: ( p_count => x_msg_count,
5723: p_data => x_msg_data
5724: );

Line 5767: -- Standard call to get message count and if count is 1, get message info.

5763: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
5764: NULL;
5765: END IF;
5766:
5767: -- Standard call to get message count and if count is 1, get message info.
5768: FND_MSG_PUB.Count_And_Get
5769: ( p_count => x_msg_count,
5770: p_data => x_msg_data
5771: );

Line 5814: -- Standard call to get message count and if count is 1, get message info.

5810: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
5811: NULL;
5812: END IF;
5813:
5814: -- Standard call to get message count and if count is 1, get message info.
5815: FND_MSG_PUB.Count_And_Get
5816: ( p_count => x_msg_count,
5817: p_data => x_msg_data
5818: );

Line 5861: -- Standard call to get message count and if count is 1, get message info.

5857: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
5858: NULL;
5859: END IF;
5860:
5861: -- Standard call to get message count and if count is 1, get message info.
5862: FND_MSG_PUB.Count_And_Get
5863: ( p_count => x_msg_count,
5864: p_data => x_msg_data
5865: );

Line 5908: -- Standard call to get message count and if count is 1, get message info.

5904: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
5905: NULL;
5906: END IF;
5907:
5908: -- Standard call to get message count and if count is 1, get message info.
5909: FND_MSG_PUB.Count_And_Get
5910: ( p_count => x_msg_count,
5911: p_data => x_msg_data
5912: );

Line 5955: -- Standard call to get message count and if count is 1, get message info.

5951: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
5952: NULL;
5953: END IF;
5954:
5955: -- Standard call to get message count and if count is 1, get message info.
5956: FND_MSG_PUB.Count_And_Get
5957: ( p_count => x_msg_count,
5958: p_data => x_msg_data
5959: );

Line 6002: -- Standard call to get message count and if count is 1, get message info.

5998: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
5999: NULL;
6000: END IF;
6001:
6002: -- Standard call to get message count and if count is 1, get message info.
6003: FND_MSG_PUB.Count_And_Get
6004: ( p_count => x_msg_count,
6005: p_data => x_msg_data
6006: );

Line 6049: -- Standard call to get message count and if count is 1, get message info.

6045: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
6046: NULL;
6047: END IF;
6048:
6049: -- Standard call to get message count and if count is 1, get message info.
6050: FND_MSG_PUB.Count_And_Get
6051: ( p_count => x_msg_count,
6052: p_data => x_msg_data
6053: );

Line 6096: -- Standard call to get message count and if count is 1, get message info.

6092: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
6093: NULL;
6094: END IF;
6095:
6096: -- Standard call to get message count and if count is 1, get message info.
6097: FND_MSG_PUB.Count_And_Get
6098: ( p_count => x_msg_count,
6099: p_data => x_msg_data
6100: );

Line 6143: -- Standard call to get message count and if count is 1, get message info.

6139: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
6140: NULL;
6141: END IF;
6142:
6143: -- Standard call to get message count and if count is 1, get message info.
6144: FND_MSG_PUB.Count_And_Get
6145: ( p_count => x_msg_count,
6146: p_data => x_msg_data
6147: );

Line 6190: -- Standard call to get message count and if count is 1, get message info.

6186: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
6187: NULL;
6188: END IF;
6189:
6190: -- Standard call to get message count and if count is 1, get message info.
6191: FND_MSG_PUB.Count_And_Get
6192: ( p_count => x_msg_count,
6193: p_data => x_msg_data
6194: );

Line 6237: -- Standard call to get message count and if count is 1, get message info.

6233: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
6234: NULL;
6235: END IF;
6236:
6237: -- Standard call to get message count and if count is 1, get message info.
6238: FND_MSG_PUB.Count_And_Get
6239: ( p_count => x_msg_count,
6240: p_data => x_msg_data
6241: );

Line 6284: -- Standard call to get message count and if count is 1, get message info.

6280: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
6281: NULL;
6282: END IF;
6283:
6284: -- Standard call to get message count and if count is 1, get message info.
6285: FND_MSG_PUB.Count_And_Get
6286: ( p_count => x_msg_count,
6287: p_data => x_msg_data
6288: );

Line 6331: -- Standard call to get message count and if count is 1, get message info.

6327: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
6328: NULL;
6329: END IF;
6330:
6331: -- Standard call to get message count and if count is 1, get message info.
6332: FND_MSG_PUB.Count_And_Get
6333: ( p_count => x_msg_count,
6334: p_data => x_msg_data
6335: );

Line 6378: -- Standard call to get message count and if count is 1, get message info.

6374: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
6375: NULL;
6376: END IF;
6377:
6378: -- Standard call to get message count and if count is 1, get message info.
6379: FND_MSG_PUB.Count_And_Get
6380: ( p_count => x_msg_count,
6381: p_data => x_msg_data
6382: );

Line 6425: -- Standard call to get message count and if count is 1, get message info.

6421: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
6422: NULL;
6423: END IF;
6424:
6425: -- Standard call to get message count and if count is 1, get message info.
6426: FND_MSG_PUB.Count_And_Get
6427: ( p_count => x_msg_count,
6428: p_data => x_msg_data
6429: );

Line 6472: -- Standard call to get message count and if count is 1, get message info.

6468: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
6469: NULL;
6470: END IF;
6471:
6472: -- Standard call to get message count and if count is 1, get message info.
6473: FND_MSG_PUB.Count_And_Get
6474: ( p_count => x_msg_count,
6475: p_data => x_msg_data
6476: );

Line 6519: -- Standard call to get message count and if count is 1, get message info.

6515: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
6516: NULL;
6517: END IF;
6518:
6519: -- Standard call to get message count and if count is 1, get message info.
6520: FND_MSG_PUB.Count_And_Get
6521: ( p_count => x_msg_count,
6522: p_data => x_msg_data
6523: );

Line 6566: -- Standard call to get message count and if count is 1, get message info.

6562: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
6563: NULL;
6564: END IF;
6565:
6566: -- Standard call to get message count and if count is 1, get message info.
6567: FND_MSG_PUB.Count_And_Get
6568: ( p_count => x_msg_count,
6569: p_data => x_msg_data
6570: );

Line 6613: -- Standard call to get message count and if count is 1, get message info.

6609: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
6610: NULL;
6611: END IF;
6612:
6613: -- Standard call to get message count and if count is 1, get message info.
6614: FND_MSG_PUB.Count_And_Get
6615: ( p_count => x_msg_count,
6616: p_data => x_msg_data
6617: );

Line 6660: -- Standard call to get message count and if count is 1, get message info.

6656: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
6657: NULL;
6658: END IF;
6659:
6660: -- Standard call to get message count and if count is 1, get message info.
6661: FND_MSG_PUB.Count_And_Get
6662: ( p_count => x_msg_count,
6663: p_data => x_msg_data
6664: );

Line 6707: -- Standard call to get message count and if count is 1, get message info.

6703: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
6704: NULL;
6705: END IF;
6706:
6707: -- Standard call to get message count and if count is 1, get message info.
6708: FND_MSG_PUB.Count_And_Get
6709: ( p_count => x_msg_count,
6710: p_data => x_msg_data
6711: );

Line 6754: -- Standard call to get message count and if count is 1, get message info.

6750: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
6751: NULL;
6752: END IF;
6753:
6754: -- Standard call to get message count and if count is 1, get message info.
6755: FND_MSG_PUB.Count_And_Get
6756: ( p_count => x_msg_count,
6757: p_data => x_msg_data
6758: );

Line 6801: -- Standard call to get message count and if count is 1, get message info.

6797: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
6798: NULL;
6799: END IF;
6800:
6801: -- Standard call to get message count and if count is 1, get message info.
6802: FND_MSG_PUB.Count_And_Get
6803: ( p_count => x_msg_count,
6804: p_data => x_msg_data
6805: );

Line 6848: -- Standard call to get message count and if count is 1, get message info.

6844: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
6845: NULL;
6846: END IF;
6847:
6848: -- Standard call to get message count and if count is 1, get message info.
6849: FND_MSG_PUB.Count_And_Get
6850: ( p_count => x_msg_count,
6851: p_data => x_msg_data
6852: );

Line 6895: -- Standard call to get message count and if count is 1, get message info.

6891: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
6892: NULL;
6893: END IF;
6894:
6895: -- Standard call to get message count and if count is 1, get message info.
6896: FND_MSG_PUB.Count_And_Get
6897: ( p_count => x_msg_count,
6898: p_data => x_msg_data
6899: );

Line 6942: -- Standard call to get message count and if count is 1, get message info.

6938: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
6939: NULL;
6940: END IF;
6941:
6942: -- Standard call to get message count and if count is 1, get message info.
6943: FND_MSG_PUB.Count_And_Get
6944: ( p_count => x_msg_count,
6945: p_data => x_msg_data
6946: );

Line 6989: -- Standard call to get message count and if count is 1, get message info.

6985: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
6986: NULL;
6987: END IF;
6988:
6989: -- Standard call to get message count and if count is 1, get message info.
6990: FND_MSG_PUB.Count_And_Get
6991: ( p_count => x_msg_count,
6992: p_data => x_msg_data
6993: );

Line 7036: -- Standard call to get message count and if count is 1, get message info.

7032: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
7033: NULL;
7034: END IF;
7035:
7036: -- Standard call to get message count and if count is 1, get message info.
7037: FND_MSG_PUB.Count_And_Get
7038: ( p_count => x_msg_count,
7039: p_data => x_msg_data
7040: );

Line 7083: -- Standard call to get message count and if count is 1, get message info.

7079: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
7080: NULL;
7081: END IF;
7082:
7083: -- Standard call to get message count and if count is 1, get message info.
7084: FND_MSG_PUB.Count_And_Get
7085: ( p_count => x_msg_count,
7086: p_data => x_msg_data
7087: );

Line 7130: -- Standard call to get message count and if count is 1, get message info.

7126: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
7127: NULL;
7128: END IF;
7129:
7130: -- Standard call to get message count and if count is 1, get message info.
7131: FND_MSG_PUB.Count_And_Get
7132: ( p_count => x_msg_count,
7133: p_data => x_msg_data
7134: );

Line 7177: -- Standard call to get message count and if count is 1, get message info.

7173: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
7174: NULL;
7175: END IF;
7176:
7177: -- Standard call to get message count and if count is 1, get message info.
7178: FND_MSG_PUB.Count_And_Get
7179: ( p_count => x_msg_count,
7180: p_data => x_msg_data
7181: );

Line 7224: -- Standard call to get message count and if count is 1, get message info.

7220: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
7221: NULL;
7222: END IF;
7223:
7224: -- Standard call to get message count and if count is 1, get message info.
7225: FND_MSG_PUB.Count_And_Get
7226: ( p_count => x_msg_count,
7227: p_data => x_msg_data
7228: );

Line 7271: -- Standard call to get message count and if count is 1, get message info.

7267: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
7268: NULL;
7269: END IF;
7270:
7271: -- Standard call to get message count and if count is 1, get message info.
7272: FND_MSG_PUB.Count_And_Get
7273: ( p_count => x_msg_count,
7274: p_data => x_msg_data
7275: );

Line 7318: -- Standard call to get message count and if count is 1, get message info.

7314: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
7315: NULL;
7316: END IF;
7317:
7318: -- Standard call to get message count and if count is 1, get message info.
7319: FND_MSG_PUB.Count_And_Get
7320: ( p_count => x_msg_count,
7321: p_data => x_msg_data
7322: );

Line 7365: -- Standard call to get message count and if count is 1, get message info.

7361: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
7362: NULL;
7363: END IF;
7364:
7365: -- Standard call to get message count and if count is 1, get message info.
7366: FND_MSG_PUB.Count_And_Get
7367: ( p_count => x_msg_count,
7368: p_data => x_msg_data
7369: );

Line 7412: -- Standard call to get message count and if count is 1, get message info.

7408: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
7409: NULL;
7410: END IF;
7411:
7412: -- Standard call to get message count and if count is 1, get message info.
7413: FND_MSG_PUB.Count_And_Get
7414: ( p_count => x_msg_count,
7415: p_data => x_msg_data
7416: );

Line 7459: -- Standard call to get message count and if count is 1, get message info.

7455: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
7456: NULL;
7457: END IF;
7458:
7459: -- Standard call to get message count and if count is 1, get message info.
7460: FND_MSG_PUB.Count_And_Get
7461: ( p_count => x_msg_count,
7462: p_data => x_msg_data
7463: );

Line 7506: -- Standard call to get message count and if count is 1, get message info.

7502: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
7503: NULL;
7504: END IF;
7505:
7506: -- Standard call to get message count and if count is 1, get message info.
7507: FND_MSG_PUB.Count_And_Get
7508: ( p_count => x_msg_count,
7509: p_data => x_msg_data
7510: );

Line 7553: -- Standard call to get message count and if count is 1, get message info.

7549: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
7550: NULL;
7551: END IF;
7552:
7553: -- Standard call to get message count and if count is 1, get message info.
7554: FND_MSG_PUB.Count_And_Get
7555: ( p_count => x_msg_count,
7556: p_data => x_msg_data
7557: );

Line 7600: -- Standard call to get message count and if count is 1, get message info.

7596: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
7597: NULL;
7598: END IF;
7599:
7600: -- Standard call to get message count and if count is 1, get message info.
7601: FND_MSG_PUB.Count_And_Get
7602: ( p_count => x_msg_count,
7603: p_data => x_msg_data
7604: );

Line 7647: -- Standard call to get message count and if count is 1, get message info.

7643: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
7644: NULL;
7645: END IF;
7646:
7647: -- Standard call to get message count and if count is 1, get message info.
7648: FND_MSG_PUB.Count_And_Get
7649: ( p_count => x_msg_count,
7650: p_data => x_msg_data
7651: );

Line 7694: -- Standard call to get message count and if count is 1, get message info.

7690: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
7691: NULL;
7692: END IF;
7693:
7694: -- Standard call to get message count and if count is 1, get message info.
7695: FND_MSG_PUB.Count_And_Get
7696: ( p_count => x_msg_count,
7697: p_data => x_msg_data
7698: );

Line 7741: -- Standard call to get message count and if count is 1, get message info.

7737: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
7738: NULL;
7739: END IF;
7740:
7741: -- Standard call to get message count and if count is 1, get message info.
7742: FND_MSG_PUB.Count_And_Get
7743: ( p_count => x_msg_count,
7744: p_data => x_msg_data
7745: );

Line 7788: -- Standard call to get message count and if count is 1, get message info.

7784: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
7785: NULL;
7786: END IF;
7787:
7788: -- Standard call to get message count and if count is 1, get message info.
7789: FND_MSG_PUB.Count_And_Get
7790: ( p_count => x_msg_count,
7791: p_data => x_msg_data
7792: );

Line 7835: -- Standard call to get message count and if count is 1, get message info.

7831: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
7832: NULL;
7833: END IF;
7834:
7835: -- Standard call to get message count and if count is 1, get message info.
7836: FND_MSG_PUB.Count_And_Get
7837: ( p_count => x_msg_count,
7838: p_data => x_msg_data
7839: );

Line 7882: -- Standard call to get message count and if count is 1, get message info.

7878: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
7879: NULL;
7880: END IF;
7881:
7882: -- Standard call to get message count and if count is 1, get message info.
7883: FND_MSG_PUB.Count_And_Get
7884: ( p_count => x_msg_count,
7885: p_data => x_msg_data
7886: );

Line 7929: -- Standard call to get message count and if count is 1, get message info.

7925: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
7926: NULL;
7927: END IF;
7928:
7929: -- Standard call to get message count and if count is 1, get message info.
7930: FND_MSG_PUB.Count_And_Get
7931: ( p_count => x_msg_count,
7932: p_data => x_msg_data
7933: );

Line 7976: -- Standard call to get message count and if count is 1, get message info.

7972: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
7973: NULL;
7974: END IF;
7975:
7976: -- Standard call to get message count and if count is 1, get message info.
7977: FND_MSG_PUB.Count_And_Get
7978: ( p_count => x_msg_count,
7979: p_data => x_msg_data
7980: );

Line 8023: -- Standard call to get message count and if count is 1, get message info.

8019: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
8020: NULL;
8021: END IF;
8022:
8023: -- Standard call to get message count and if count is 1, get message info.
8024: FND_MSG_PUB.Count_And_Get
8025: ( p_count => x_msg_count,
8026: p_data => x_msg_data
8027: );

Line 8070: -- Standard call to get message count and if count is 1, get message info.

8066: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
8067: NULL;
8068: END IF;
8069:
8070: -- Standard call to get message count and if count is 1, get message info.
8071: FND_MSG_PUB.Count_And_Get
8072: ( p_count => x_msg_count,
8073: p_data => x_msg_data
8074: );

Line 8117: -- Standard call to get message count and if count is 1, get message info.

8113: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
8114: NULL;
8115: END IF;
8116:
8117: -- Standard call to get message count and if count is 1, get message info.
8118: FND_MSG_PUB.Count_And_Get
8119: ( p_count => x_msg_count,
8120: p_data => x_msg_data
8121: );

Line 8164: -- Standard call to get message count and if count is 1, get message info.

8160: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
8161: NULL;
8162: END IF;
8163:
8164: -- Standard call to get message count and if count is 1, get message info.
8165: FND_MSG_PUB.Count_And_Get
8166: ( p_count => x_msg_count,
8167: p_data => x_msg_data
8168: );

Line 8211: -- Standard call to get message count and if count is 1, get message info.

8207: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
8208: NULL;
8209: END IF;
8210:
8211: -- Standard call to get message count and if count is 1, get message info.
8212: FND_MSG_PUB.Count_And_Get
8213: ( p_count => x_msg_count,
8214: p_data => x_msg_data
8215: );

Line 8258: -- Standard call to get message count and if count is 1, get message info.

8254: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
8255: NULL;
8256: END IF;
8257:
8258: -- Standard call to get message count and if count is 1, get message info.
8259: FND_MSG_PUB.Count_And_Get
8260: ( p_count => x_msg_count,
8261: p_data => x_msg_data
8262: );

Line 8305: -- Standard call to get message count and if count is 1, get message info.

8301: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
8302: NULL;
8303: END IF;
8304:
8305: -- Standard call to get message count and if count is 1, get message info.
8306: FND_MSG_PUB.Count_And_Get
8307: ( p_count => x_msg_count,
8308: p_data => x_msg_data
8309: );

Line 8352: -- Standard call to get message count and if count is 1, get message info.

8348: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
8349: NULL;
8350: END IF;
8351:
8352: -- Standard call to get message count and if count is 1, get message info.
8353: FND_MSG_PUB.Count_And_Get
8354: ( p_count => x_msg_count,
8355: p_data => x_msg_data
8356: );

Line 8399: -- Standard call to get message count and if count is 1, get message info.

8395: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
8396: NULL;
8397: END IF;
8398:
8399: -- Standard call to get message count and if count is 1, get message info.
8400: FND_MSG_PUB.Count_And_Get
8401: ( p_count => x_msg_count,
8402: p_data => x_msg_data
8403: );

Line 8446: -- Standard call to get message count and if count is 1, get message info.

8442: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
8443: NULL;
8444: END IF;
8445:
8446: -- Standard call to get message count and if count is 1, get message info.
8447: FND_MSG_PUB.Count_And_Get
8448: ( p_count => x_msg_count,
8449: p_data => x_msg_data
8450: );

Line 8493: -- Standard call to get message count and if count is 1, get message info.

8489: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
8490: NULL;
8491: END IF;
8492:
8493: -- Standard call to get message count and if count is 1, get message info.
8494: FND_MSG_PUB.Count_And_Get
8495: ( p_count => x_msg_count,
8496: p_data => x_msg_data
8497: );

Line 8540: -- Standard call to get message count and if count is 1, get message info.

8536: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
8537: NULL;
8538: END IF;
8539:
8540: -- Standard call to get message count and if count is 1, get message info.
8541: FND_MSG_PUB.Count_And_Get
8542: ( p_count => x_msg_count,
8543: p_data => x_msg_data
8544: );

Line 8587: -- Standard call to get message count and if count is 1, get message info.

8583: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
8584: NULL;
8585: END IF;
8586:
8587: -- Standard call to get message count and if count is 1, get message info.
8588: FND_MSG_PUB.Count_And_Get
8589: ( p_count => x_msg_count,
8590: p_data => x_msg_data
8591: );

Line 8634: -- Standard call to get message count and if count is 1, get message info.

8630: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
8631: NULL;
8632: END IF;
8633:
8634: -- Standard call to get message count and if count is 1, get message info.
8635: FND_MSG_PUB.Count_And_Get
8636: ( p_count => x_msg_count,
8637: p_data => x_msg_data
8638: );

Line 8681: -- Standard call to get message count and if count is 1, get message info.

8677: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
8678: NULL;
8679: END IF;
8680:
8681: -- Standard call to get message count and if count is 1, get message info.
8682: FND_MSG_PUB.Count_And_Get
8683: ( p_count => x_msg_count,
8684: p_data => x_msg_data
8685: );

Line 8728: -- Standard call to get message count and if count is 1, get message info.

8724: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
8725: NULL;
8726: END IF;
8727:
8728: -- Standard call to get message count and if count is 1, get message info.
8729: FND_MSG_PUB.Count_And_Get
8730: ( p_count => x_msg_count,
8731: p_data => x_msg_data
8732: );

Line 8775: -- Standard call to get message count and if count is 1, get message info.

8771: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
8772: NULL;
8773: END IF;
8774:
8775: -- Standard call to get message count and if count is 1, get message info.
8776: FND_MSG_PUB.Count_And_Get
8777: ( p_count => x_msg_count,
8778: p_data => x_msg_data
8779: );

Line 8822: -- Standard call to get message count and if count is 1, get message info.

8818: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
8819: NULL;
8820: END IF;
8821:
8822: -- Standard call to get message count and if count is 1, get message info.
8823: FND_MSG_PUB.Count_And_Get
8824: ( p_count => x_msg_count,
8825: p_data => x_msg_data
8826: );

Line 8869: -- Standard call to get message count and if count is 1, get message info.

8865: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
8866: NULL;
8867: END IF;
8868:
8869: -- Standard call to get message count and if count is 1, get message info.
8870: FND_MSG_PUB.Count_And_Get
8871: ( p_count => x_msg_count,
8872: p_data => x_msg_data
8873: );

Line 8916: -- Standard call to get message count and if count is 1, get message info.

8912: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
8913: NULL;
8914: END IF;
8915:
8916: -- Standard call to get message count and if count is 1, get message info.
8917: FND_MSG_PUB.Count_And_Get
8918: ( p_count => x_msg_count,
8919: p_data => x_msg_data
8920: );

Line 8963: -- Standard call to get message count and if count is 1, get message info.

8959: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
8960: NULL;
8961: END IF;
8962:
8963: -- Standard call to get message count and if count is 1, get message info.
8964: FND_MSG_PUB.Count_And_Get
8965: ( p_count => x_msg_count,
8966: p_data => x_msg_data
8967: );

Line 9010: -- Standard call to get message count and if count is 1, get message info.

9006: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
9007: NULL;
9008: END IF;
9009:
9010: -- Standard call to get message count and if count is 1, get message info.
9011: FND_MSG_PUB.Count_And_Get
9012: ( p_count => x_msg_count,
9013: p_data => x_msg_data
9014: );

Line 9057: -- Standard call to get message count and if count is 1, get message info.

9053: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
9054: NULL;
9055: END IF;
9056:
9057: -- Standard call to get message count and if count is 1, get message info.
9058: FND_MSG_PUB.Count_And_Get
9059: ( p_count => x_msg_count,
9060: p_data => x_msg_data
9061: );

Line 9104: -- Standard call to get message count and if count is 1, get message info.

9100: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
9101: NULL;
9102: END IF;
9103:
9104: -- Standard call to get message count and if count is 1, get message info.
9105: FND_MSG_PUB.Count_And_Get
9106: ( p_count => x_msg_count,
9107: p_data => x_msg_data
9108: );

Line 9151: -- Standard call to get message count and if count is 1, get message info.

9147: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
9148: NULL;
9149: END IF;
9150:
9151: -- Standard call to get message count and if count is 1, get message info.
9152: FND_MSG_PUB.Count_And_Get
9153: ( p_count => x_msg_count,
9154: p_data => x_msg_data
9155: );

Line 9198: -- Standard call to get message count and if count is 1, get message info.

9194: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
9195: NULL;
9196: END IF;
9197:
9198: -- Standard call to get message count and if count is 1, get message info.
9199: FND_MSG_PUB.Count_And_Get
9200: ( p_count => x_msg_count,
9201: p_data => x_msg_data
9202: );

Line 9245: -- Standard call to get message count and if count is 1, get message info.

9241: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
9242: NULL;
9243: END IF;
9244:
9245: -- Standard call to get message count and if count is 1, get message info.
9246: FND_MSG_PUB.Count_And_Get
9247: ( p_count => x_msg_count,
9248: p_data => x_msg_data
9249: );

Line 9292: -- Standard call to get message count and if count is 1, get message info.

9288: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
9289: NULL;
9290: END IF;
9291:
9292: -- Standard call to get message count and if count is 1, get message info.
9293: FND_MSG_PUB.Count_And_Get
9294: ( p_count => x_msg_count,
9295: p_data => x_msg_data
9296: );

Line 9339: -- Standard call to get message count and if count is 1, get message info.

9335: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
9336: NULL;
9337: END IF;
9338:
9339: -- Standard call to get message count and if count is 1, get message info.
9340: FND_MSG_PUB.Count_And_Get
9341: ( p_count => x_msg_count,
9342: p_data => x_msg_data
9343: );

Line 9386: -- Standard call to get message count and if count is 1, get message info.

9382: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
9383: NULL;
9384: END IF;
9385:
9386: -- Standard call to get message count and if count is 1, get message info.
9387: FND_MSG_PUB.Count_And_Get
9388: ( p_count => x_msg_count,
9389: p_data => x_msg_data
9390: );

Line 9433: -- Standard call to get message count and if count is 1, get message info.

9429: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
9430: NULL;
9431: END IF;
9432:
9433: -- Standard call to get message count and if count is 1, get message info.
9434: FND_MSG_PUB.Count_And_Get
9435: ( p_count => x_msg_count,
9436: p_data => x_msg_data
9437: );

Line 9480: -- Standard call to get message count and if count is 1, get message info.

9476: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
9477: NULL;
9478: END IF;
9479:
9480: -- Standard call to get message count and if count is 1, get message info.
9481: FND_MSG_PUB.Count_And_Get
9482: ( p_count => x_msg_count,
9483: p_data => x_msg_data
9484: );

Line 9527: -- Standard call to get message count and if count is 1, get message info.

9523: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
9524: NULL;
9525: END IF;
9526:
9527: -- Standard call to get message count and if count is 1, get message info.
9528: FND_MSG_PUB.Count_And_Get
9529: ( p_count => x_msg_count,
9530: p_data => x_msg_data
9531: );

Line 9574: -- Standard call to get message count and if count is 1, get message info.

9570: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
9571: NULL;
9572: END IF;
9573:
9574: -- Standard call to get message count and if count is 1, get message info.
9575: FND_MSG_PUB.Count_And_Get
9576: ( p_count => x_msg_count,
9577: p_data => x_msg_data
9578: );

Line 9621: -- Standard call to get message count and if count is 1, get message info.

9617: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
9618: NULL;
9619: END IF;
9620:
9621: -- Standard call to get message count and if count is 1, get message info.
9622: FND_MSG_PUB.Count_And_Get
9623: ( p_count => x_msg_count,
9624: p_data => x_msg_data
9625: );

Line 9668: -- Standard call to get message count and if count is 1, get message info.

9664: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
9665: NULL;
9666: END IF;
9667:
9668: -- Standard call to get message count and if count is 1, get message info.
9669: FND_MSG_PUB.Count_And_Get
9670: ( p_count => x_msg_count,
9671: p_data => x_msg_data
9672: );

Line 9715: -- Standard call to get message count and if count is 1, get message info.

9711: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
9712: NULL;
9713: END IF;
9714:
9715: -- Standard call to get message count and if count is 1, get message info.
9716: FND_MSG_PUB.Count_And_Get
9717: ( p_count => x_msg_count,
9718: p_data => x_msg_data
9719: );

Line 9762: -- Standard call to get message count and if count is 1, get message info.

9758: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
9759: NULL;
9760: END IF;
9761:
9762: -- Standard call to get message count and if count is 1, get message info.
9763: FND_MSG_PUB.Count_And_Get
9764: ( p_count => x_msg_count,
9765: p_data => x_msg_data
9766: );

Line 9809: -- Standard call to get message count and if count is 1, get message info.

9805: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
9806: NULL;
9807: END IF;
9808:
9809: -- Standard call to get message count and if count is 1, get message info.
9810: FND_MSG_PUB.Count_And_Get
9811: ( p_count => x_msg_count,
9812: p_data => x_msg_data
9813: );

Line 9851: -- Standard call to get message count and if count is 1, get message info.

9847:
9848: -- Debug Message
9849: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'API_INVALID_RECORD');
9850:
9851: -- Standard call to get message count and if count is 1, get message info.
9852: FND_MSG_PUB.Count_And_Get
9853: ( p_count => x_msg_count,
9854: p_data => x_msg_data
9855: );