427:
428: IF l_change_id IS NULL
429: THEN
430:
431: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
432: FND_MESSAGE.Set_Token('OBJECT_NAME', 'GetChangeId:'|| 'no change Id');
433: FND_MSG_PUB.Add;
434: RAISE FND_API.G_EXC_ERROR;
435:
428: IF l_change_id IS NULL
429: THEN
430:
431: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
432: FND_MESSAGE.Set_Token('OBJECT_NAME', 'GetChangeId:'|| 'no change Id');
433: FND_MSG_PUB.Add;
434: RAISE FND_API.G_EXC_ERROR;
435:
436: END IF ;
1220:
1221: x_return_status := l_return_status;
1222: x_msg_count := l_msg_count;
1223: x_msg_data := l_msg_data;
1224: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
1225: FND_MESSAGE.Set_Token('OBJECT_NAME', 'ENG_IMPL_ITEM_CHANGES_PKG.impl_rev_item_user_attr_chgs');
1226: FND_MSG_PUB.Add;
1227:
1228: RAISE FND_API.G_EXC_ERROR;
1221: x_return_status := l_return_status;
1222: x_msg_count := l_msg_count;
1223: x_msg_data := l_msg_data;
1224: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
1225: FND_MESSAGE.Set_Token('OBJECT_NAME', 'ENG_IMPL_ITEM_CHANGES_PKG.impl_rev_item_user_attr_chgs');
1226: FND_MSG_PUB.Add;
1227:
1228: RAISE FND_API.G_EXC_ERROR;
1229:
1280:
1281: x_return_status := l_return_status;
1282: x_msg_count := l_msg_count;
1283: x_msg_data := l_msg_data;
1284: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
1285: FND_MESSAGE.Set_Token('OBJECT_NAME', 'ENG_IMPL_ITEM_CHANGES_PKG.impl_rev_item_gdsn_attr_chgs');
1286: FND_MSG_PUB.Add;
1287:
1288: RAISE FND_API.G_EXC_ERROR;
1281: x_return_status := l_return_status;
1282: x_msg_count := l_msg_count;
1283: x_msg_data := l_msg_data;
1284: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
1285: FND_MESSAGE.Set_Token('OBJECT_NAME', 'ENG_IMPL_ITEM_CHANGES_PKG.impl_rev_item_gdsn_attr_chgs');
1286: FND_MSG_PUB.Add;
1287:
1288: RAISE FND_API.G_EXC_ERROR;
1289:
1314: x_return_status := l_return_status;
1315: x_msg_count := l_msg_count;
1316: x_msg_data := l_msg_data;
1317:
1318: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
1319: FND_MESSAGE.Set_Token('OBJECT_NAME', 'ENG_IMPL_ITEM_CHANGES_PKG.impl_rev_item_aml_changes');
1320: FND_MSG_PUB.Add;
1321:
1322: RAISE FND_API.G_EXC_ERROR;
1315: x_msg_count := l_msg_count;
1316: x_msg_data := l_msg_data;
1317:
1318: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
1319: FND_MESSAGE.Set_Token('OBJECT_NAME', 'ENG_IMPL_ITEM_CHANGES_PKG.impl_rev_item_aml_changes');
1320: FND_MSG_PUB.Add;
1321:
1322: RAISE FND_API.G_EXC_ERROR;
1323:
1432: END IF;
1433:
1434: Write_Debug('When Others Exception ' || Substr(To_Char(SQLCODE)||'/'||SQLERRM,1,240));
1435:
1436: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
1437: FND_MESSAGE.Set_Token('OBJECT_NAME', 'ENG_IMPL_ITEM_CHANGES_PKG.impl_item_changes for ChangeId: '||l_change_id || '- ChangeLineId: '||l_change_line_id);
1438: FND_MSG_PUB.Add;
1439:
1440:
1433:
1434: Write_Debug('When Others Exception ' || Substr(To_Char(SQLCODE)||'/'||SQLERRM,1,240));
1435:
1436: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
1437: FND_MESSAGE.Set_Token('OBJECT_NAME', 'ENG_IMPL_ITEM_CHANGES_PKG.impl_item_changes for ChangeId: '||l_change_id || '- ChangeLineId: '||l_change_line_id);
1438: FND_MSG_PUB.Add;
1439:
1440:
1441: IF FND_MSG_PUB.Check_Msg_Level
2132: -- Acd Type maybe ADD or DELETE or Invalid one
2133: Write_Debug('Item Attr Change Imple does not support ACD Type: ' || l_current_acd_type);
2134:
2135: -- We don't support this in R12
2136: FND_MESSAGE.Set_Name('ENG','ENG_IMPL_INVALID_ACD_TYPE');
2137: FND_MESSAGE.Set_Token('ACD_TYPE', l_current_acd_type);
2138: FND_MSG_PUB.Add;
2139: RAISE FND_API.G_EXC_ERROR;
2140:
2133: Write_Debug('Item Attr Change Imple does not support ACD Type: ' || l_current_acd_type);
2134:
2135: -- We don't support this in R12
2136: FND_MESSAGE.Set_Name('ENG','ENG_IMPL_INVALID_ACD_TYPE');
2137: FND_MESSAGE.Set_Token('ACD_TYPE', l_current_acd_type);
2138: FND_MSG_PUB.Add;
2139: RAISE FND_API.G_EXC_ERROR;
2140:
2141: END IF;
2395: p_error_text => Substr(To_Char(SQLCODE)||'/'||SQLERRM,1,240)
2396: );
2397:
2398:
2399: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
2400: FND_MESSAGE.Set_Token('OBJECT_NAME', 'EGO_ITEM_PUB.Process_Item');
2401: FND_MSG_PUB.Add;
2402:
2403: Write_Debug('When Others Exception while calling EGO_ITEM_PUB.Process_Item' || Substr(To_Char(SQLCODE)||'/'||SQLERRM,1,240));
2396: );
2397:
2398:
2399: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
2400: FND_MESSAGE.Set_Token('OBJECT_NAME', 'EGO_ITEM_PUB.Process_Item');
2401: FND_MSG_PUB.Add;
2402:
2403: Write_Debug('When Others Exception while calling EGO_ITEM_PUB.Process_Item' || Substr(To_Char(SQLCODE)||'/'||SQLERRM,1,240));
2404: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2442: Write_Debug('Output - Return Stattus: ' || l_return_status);
2443: Write_Debug('Output - Return Stattus: ' || to_char(l_msg_count));
2444: Write_Debug('Output - Return Stattus: ' || substr(l_msg_data,1,200));
2445:
2446: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
2447: FND_MESSAGE.Set_Token('OBJECT_NAME', 'EGO_ITEM_PUB.Process_Item');
2448: FND_MSG_PUB.Add;
2449:
2450: RAISE FND_API.G_EXC_ERROR ;
2443: Write_Debug('Output - Return Stattus: ' || to_char(l_msg_count));
2444: Write_Debug('Output - Return Stattus: ' || substr(l_msg_data,1,200));
2445:
2446: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
2447: FND_MESSAGE.Set_Token('OBJECT_NAME', 'EGO_ITEM_PUB.Process_Item');
2448: FND_MSG_PUB.Add;
2449:
2450: RAISE FND_API.G_EXC_ERROR ;
2451:
2520: Write_Debug('Rollback to IMPL_REV_ITEM_ATTR_CHGS Item Attribute Change Implementation ');
2521: ROLLBACK TO IMPL_REV_ITEM_ATTR_CHGS;
2522: END IF;
2523:
2524: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
2525: FND_MESSAGE.Set_Token('OBJECT_NAME', 'ENG_IMPL_ITEM_CHANGES_PKG.impl_rev_item_attr_changes for ChangeId: '||l_change_id || '- ChangeLineId: '||l_change_line_id);
2526: FND_MSG_PUB.Add;
2527:
2528:
2521: ROLLBACK TO IMPL_REV_ITEM_ATTR_CHGS;
2522: END IF;
2523:
2524: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
2525: FND_MESSAGE.Set_Token('OBJECT_NAME', 'ENG_IMPL_ITEM_CHANGES_PKG.impl_rev_item_attr_changes for ChangeId: '||l_change_id || '- ChangeLineId: '||l_change_line_id);
2526: FND_MSG_PUB.Add;
2527:
2528:
2529: FND_MSG_PUB.Count_And_Get
2551: ROLLBACK TO IMPL_REV_ITEM_ATTR_CHGS;
2552: END IF;
2553:
2554:
2555: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
2556: FND_MESSAGE.Set_Token('OBJECT_NAME', 'ENG_IMPL_ITEM_CHANGES_PKG.impl_rev_item_attr_changes for ChangeId: '||l_change_id || '- ChangeLineId: '||l_change_line_id);
2557: FND_MSG_PUB.Add;
2558:
2559: FND_MSG_PUB.Count_And_Get
2552: END IF;
2553:
2554:
2555: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
2556: FND_MESSAGE.Set_Token('OBJECT_NAME', 'ENG_IMPL_ITEM_CHANGES_PKG.impl_rev_item_attr_changes for ChangeId: '||l_change_id || '- ChangeLineId: '||l_change_line_id);
2557: FND_MSG_PUB.Add;
2558:
2559: FND_MSG_PUB.Count_And_Get
2560: ( p_count => x_msg_count ,
2586:
2587: Write_Debug('When Others Exception ' || Substr(To_Char(SQLCODE)||'/'||SQLERRM,1,240));
2588:
2589:
2590: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
2591: FND_MESSAGE.Set_Token('OBJECT_NAME', 'ENG_IMPL_ITEM_CHANGES_PKG.impl_rev_item_attr_changes for ChangeId: '||l_change_id || '- ChangeLineId: '||l_change_line_id);
2592: FND_MSG_PUB.Add;
2593:
2594:
2587: Write_Debug('When Others Exception ' || Substr(To_Char(SQLCODE)||'/'||SQLERRM,1,240));
2588:
2589:
2590: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
2591: FND_MESSAGE.Set_Token('OBJECT_NAME', 'ENG_IMPL_ITEM_CHANGES_PKG.impl_rev_item_attr_changes for ChangeId: '||l_change_id || '- ChangeLineId: '||l_change_line_id);
2592: FND_MSG_PUB.Add;
2593:
2594:
2595: IF FND_MSG_PUB.Check_Msg_Level
2779: p_error_text => Substr(To_Char(SQLCODE)||'/'||SQLERRM,1,240)
2780: );
2781:
2782:
2783: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
2784: FND_MESSAGE.Set_Token('OBJECT_NAME', 'EGO_ITEM_AML_PUB.Implement_AML_Changes');
2785: FND_MSG_PUB.Add;
2786:
2787: Write_Debug('When Others Exception while calling EGO_ITEM_AML_PUB.Implement_AML_Changes:' || Substr(To_Char(SQLCODE)||'/'||SQLERRM,1,240));
2780: );
2781:
2782:
2783: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
2784: FND_MESSAGE.Set_Token('OBJECT_NAME', 'EGO_ITEM_AML_PUB.Implement_AML_Changes');
2785: FND_MSG_PUB.Add;
2786:
2787: Write_Debug('When Others Exception while calling EGO_ITEM_AML_PUB.Implement_AML_Changes:' || Substr(To_Char(SQLCODE)||'/'||SQLERRM,1,240));
2788: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2799: Write_Debug('Output - Return Stattus: ' || to_char(l_msg_count));
2800: Write_Debug('Output - Return Stattus: ' || substr(l_msg_data,1,200));
2801:
2802:
2803: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
2804: FND_MESSAGE.Set_Token('OBJECT_NAME', 'EGO_ITEM_AML_PUB.Implement_AML_Changes');
2805: FND_MSG_PUB.Add;
2806:
2807: RAISE FND_API.G_EXC_ERROR;
2800: Write_Debug('Output - Return Stattus: ' || substr(l_msg_data,1,200));
2801:
2802:
2803: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
2804: FND_MESSAGE.Set_Token('OBJECT_NAME', 'EGO_ITEM_AML_PUB.Implement_AML_Changes');
2805: FND_MSG_PUB.Add;
2806:
2807: RAISE FND_API.G_EXC_ERROR;
2808: END IF;
2846: Write_Debug('ROLLBACK Item AML Changes implementation to IMPL_REV_ITEM_AML_CHANGES');
2847: ROLLBACK TO IMPL_REV_ITEM_AML_CHANGES;
2848: END IF;
2849:
2850: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
2851: FND_MESSAGE.Set_Token('OBJECT_NAME', 'ENG_IMPL_ITEM_CHANGES_PKG.impl_rev_item_aml_changes for ChangeId: '||l_change_id || '- ChangeLineId: '||l_change_line_id);
2852: FND_MSG_PUB.Add;
2853:
2854:
2847: ROLLBACK TO IMPL_REV_ITEM_AML_CHANGES;
2848: END IF;
2849:
2850: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
2851: FND_MESSAGE.Set_Token('OBJECT_NAME', 'ENG_IMPL_ITEM_CHANGES_PKG.impl_rev_item_aml_changes for ChangeId: '||l_change_id || '- ChangeLineId: '||l_change_line_id);
2852: FND_MSG_PUB.Add;
2853:
2854:
2855: FND_MSG_PUB.Count_And_Get
2877: ROLLBACK TO IMPL_REV_ITEM_AML_CHANGES;
2878: END IF;
2879:
2880:
2881: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
2882: FND_MESSAGE.Set_Token('OBJECT_NAME', 'ENG_IMPL_ITEM_CHANGES_PKG.impl_rev_item_aml_changes for ChangeId: '||l_change_id || '- ChangeLineId: '||l_change_line_id);
2883: FND_MSG_PUB.Add;
2884:
2885: FND_MSG_PUB.Count_And_Get
2878: END IF;
2879:
2880:
2881: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
2882: FND_MESSAGE.Set_Token('OBJECT_NAME', 'ENG_IMPL_ITEM_CHANGES_PKG.impl_rev_item_aml_changes for ChangeId: '||l_change_id || '- ChangeLineId: '||l_change_line_id);
2883: FND_MSG_PUB.Add;
2884:
2885: FND_MSG_PUB.Count_And_Get
2886: ( p_count => x_msg_count ,
2909:
2910:
2911: Write_Debug('When Others Exception ' || Substr(To_Char(SQLCODE)||'/'||SQLERRM,1,240));
2912:
2913: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
2914: FND_MESSAGE.Set_Token('OBJECT_NAME', 'ENG_IMPL_ITEM_CHANGES_PKG.impl_rev_item_aml_changes for ChangeId: '||l_change_id || '- ChangeLineId: '||l_change_line_id);
2915: FND_MSG_PUB.Add;
2916:
2917:
2910:
2911: Write_Debug('When Others Exception ' || Substr(To_Char(SQLCODE)||'/'||SQLERRM,1,240));
2912:
2913: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
2914: FND_MESSAGE.Set_Token('OBJECT_NAME', 'ENG_IMPL_ITEM_CHANGES_PKG.impl_rev_item_aml_changes for ChangeId: '||l_change_id || '- ChangeLineId: '||l_change_line_id);
2915: FND_MSG_PUB.Add;
2916:
2917:
2918: IF FND_MSG_PUB.Check_Msg_Level
3625: ELSE
3626: Write_Debug('Item Attr Change Imple does not support ACD Type: ' || l_current_acd_type);
3627:
3628: -- We don't support this in R12
3629: FND_MESSAGE.Set_Name('ENG','ENG_IMPL_INVALID_ACD_TYPE');
3630: FND_MESSAGE.Set_Token('ACD_TYPE', l_current_acd_type);
3631: FND_MSG_PUB.Add;
3632: RAISE FND_API.G_EXC_ERROR;
3633:
3626: Write_Debug('Item Attr Change Imple does not support ACD Type: ' || l_current_acd_type);
3627:
3628: -- We don't support this in R12
3629: FND_MESSAGE.Set_Name('ENG','ENG_IMPL_INVALID_ACD_TYPE');
3630: FND_MESSAGE.Set_Token('ACD_TYPE', l_current_acd_type);
3631: FND_MSG_PUB.Add;
3632: RAISE FND_API.G_EXC_ERROR;
3633:
3634:
4088: -- Invalid Case
4089: Write_Debug('Item Attr Change Imple does not support ACD Type: ' || l_current_acd_type);
4090:
4091: -- We don't support this in R12
4092: FND_MESSAGE.Set_Name('ENG','ENG_IMPL_INVALID_ACD_TYPE');
4093: FND_MESSAGE.Set_Token('ACD_TYPE', l_current_acd_type);
4094: FND_MSG_PUB.Add;
4095: RAISE FND_API.G_EXC_ERROR;
4096:
4089: Write_Debug('Item Attr Change Imple does not support ACD Type: ' || l_current_acd_type);
4090:
4091: -- We don't support this in R12
4092: FND_MESSAGE.Set_Name('ENG','ENG_IMPL_INVALID_ACD_TYPE');
4093: FND_MESSAGE.Set_Token('ACD_TYPE', l_current_acd_type);
4094: FND_MSG_PUB.Add;
4095: RAISE FND_API.G_EXC_ERROR;
4096:
4097: END IF;
4277: p_procedure_name => 'Process_UCCnet_Attrs_For_Item',
4278: p_error_text => Substr(To_Char(SQLCODE)||'/'||SQLERRM,1,240)
4279: );
4280:
4281: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
4282: FND_MESSAGE.Set_Token('OBJECT_NAME', 'EGO_GTIN_ATTRS_PVT.Process_UCCnet_Attrs_For_Item');
4283: FND_MSG_PUB.Add;
4284:
4285: Write_Debug('When Others Exception while calling EGO_GTIN_ATTRS_PVT.Process_UCCnet_Attrs_For_Item' || Substr(To_Char(SQLCODE)||'/'||SQLERRM,1,240));
4278: p_error_text => Substr(To_Char(SQLCODE)||'/'||SQLERRM,1,240)
4279: );
4280:
4281: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
4282: FND_MESSAGE.Set_Token('OBJECT_NAME', 'EGO_GTIN_ATTRS_PVT.Process_UCCnet_Attrs_For_Item');
4283: FND_MSG_PUB.Add;
4284:
4285: Write_Debug('When Others Exception while calling EGO_GTIN_ATTRS_PVT.Process_UCCnet_Attrs_For_Item' || Substr(To_Char(SQLCODE)||'/'||SQLERRM,1,240));
4286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4306:
4307: x_return_status := l_return_status;
4308: x_msg_count := l_msg_count;
4309: x_msg_data := l_msg_data;
4310: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
4311: FND_MESSAGE.Set_Token('OBJECT_NAME', 'EGO_GTIN_ATTRS_PVT.Process_UCCnet_Attrs_For_Item');
4312: FND_MSG_PUB.Add;
4313:
4314: RAISE FND_API.G_EXC_ERROR ;
4307: x_return_status := l_return_status;
4308: x_msg_count := l_msg_count;
4309: x_msg_data := l_msg_data;
4310: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
4311: FND_MESSAGE.Set_Token('OBJECT_NAME', 'EGO_GTIN_ATTRS_PVT.Process_UCCnet_Attrs_For_Item');
4312: FND_MSG_PUB.Add;
4313:
4314: RAISE FND_API.G_EXC_ERROR ;
4315:
4397: Write_Debug('ROLLBACK Item GDSN Attribute Change Implementation TO IMPL_REV_ITEM_GDSN_ATTR_CHGS');
4398: ROLLBACK TO IMPL_REV_ITEM_GDSN_ATTR_CHGS;
4399: END IF;
4400:
4401: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
4402: FND_MESSAGE.Set_Token('OBJECT_NAME', 'ENG_IMPL_ITEM_CHANGES_PKG.impl_rev_item_gdsn_attr_chgs for ChangeId: '||l_change_id || '- ChangeLineId: '||l_change_line_id);
4403: FND_MSG_PUB.Add;
4404:
4405:
4398: ROLLBACK TO IMPL_REV_ITEM_GDSN_ATTR_CHGS;
4399: END IF;
4400:
4401: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
4402: FND_MESSAGE.Set_Token('OBJECT_NAME', 'ENG_IMPL_ITEM_CHANGES_PKG.impl_rev_item_gdsn_attr_chgs for ChangeId: '||l_change_id || '- ChangeLineId: '||l_change_line_id);
4403: FND_MSG_PUB.Add;
4404:
4405:
4406: FND_MSG_PUB.Count_And_Get
4428: ROLLBACK TO IMPL_REV_ITEM_GDSN_ATTR_CHGS;
4429: END IF;
4430:
4431:
4432: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
4433: FND_MESSAGE.Set_Token('OBJECT_NAME', 'ENG_IMPL_ITEM_CHANGES_PKG.impl_rev_item_gdsn_attr_chgs for ChangeId: '||l_change_id || '- ChangeLineId: '||l_change_line_id);
4434: FND_MSG_PUB.Add;
4435:
4436: FND_MSG_PUB.Count_And_Get
4429: END IF;
4430:
4431:
4432: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
4433: FND_MESSAGE.Set_Token('OBJECT_NAME', 'ENG_IMPL_ITEM_CHANGES_PKG.impl_rev_item_gdsn_attr_chgs for ChangeId: '||l_change_id || '- ChangeLineId: '||l_change_line_id);
4434: FND_MSG_PUB.Add;
4435:
4436: FND_MSG_PUB.Count_And_Get
4437: ( p_count => x_msg_count ,
4461:
4462:
4463: Write_Debug('When Others Exception ' || Substr(To_Char(SQLCODE)||'/'||SQLERRM,1,240));
4464:
4465: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
4466: FND_MESSAGE.Set_Token('OBJECT_NAME', 'ENG_IMPL_ITEM_CHANGES_PKG.impl_rev_item_gdsn_attr_chgs for ChangeId: '||l_change_id || '- ChangeLineId: '||l_change_line_id);
4467: FND_MSG_PUB.Add;
4468:
4469:
4462:
4463: Write_Debug('When Others Exception ' || Substr(To_Char(SQLCODE)||'/'||SQLERRM,1,240));
4464:
4465: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
4466: FND_MESSAGE.Set_Token('OBJECT_NAME', 'ENG_IMPL_ITEM_CHANGES_PKG.impl_rev_item_gdsn_attr_chgs for ChangeId: '||l_change_id || '- ChangeLineId: '||l_change_line_id);
4467: FND_MSG_PUB.Add;
4468:
4469:
4470: IF FND_MSG_PUB.Check_Msg_Level
6006: p_error_text => Substr(To_Char(SQLCODE)||'/'||SQLERRM,1,240)
6007: );
6008:
6009:
6010: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
6011: FND_MESSAGE.Set_Token('OBJECT_NAME', 'EGO_USER_ATTRS_DATA_PVT.Implement_Change_Line');
6012: FND_MSG_PUB.Add;
6013:
6014: Write_Debug('When Others Exception while calling EGO_USER_ATTRS_DATA_PVT.Implement_Change_Line:' || Substr(To_Char(SQLCODE)||'/'||SQLERRM,1,240));
6007: );
6008:
6009:
6010: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
6011: FND_MESSAGE.Set_Token('OBJECT_NAME', 'EGO_USER_ATTRS_DATA_PVT.Implement_Change_Line');
6012: FND_MSG_PUB.Add;
6013:
6014: Write_Debug('When Others Exception while calling EGO_USER_ATTRS_DATA_PVT.Implement_Change_Line:' || Substr(To_Char(SQLCODE)||'/'||SQLERRM,1,240));
6015: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6026:
6027: x_return_status := l_return_status;
6028: x_msg_count := l_msg_count;
6029: x_msg_data := l_msg_data;
6030: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
6031: FND_MESSAGE.Set_Token('OBJECT_NAME', 'EGO_USER_ATTRS_DATA_PVT.Implement_Change_Line');
6032: FND_MSG_PUB.Add;
6033:
6034: RAISE FND_API.G_EXC_ERROR ;
6027: x_return_status := l_return_status;
6028: x_msg_count := l_msg_count;
6029: x_msg_data := l_msg_data;
6030: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
6031: FND_MESSAGE.Set_Token('OBJECT_NAME', 'EGO_USER_ATTRS_DATA_PVT.Implement_Change_Line');
6032: FND_MSG_PUB.Add;
6033:
6034: RAISE FND_API.G_EXC_ERROR ;
6035: END IF;
6070: Write_Debug('ROLLBACK Item User Attribute Change Implementation TO IMPL_REV_ITEM_USER_ATTR_CHGS');
6071: ROLLBACK TO IMPL_REV_ITEM_USER_ATTR_CHGS;
6072: END IF;
6073:
6074: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
6075: FND_MESSAGE.Set_Token('OBJECT_NAME', 'impl_rev_item_attr_changes'|| 'error code '||l_errorcode);
6076: FND_MSG_PUB.Add;
6077:
6078:
6071: ROLLBACK TO IMPL_REV_ITEM_USER_ATTR_CHGS;
6072: END IF;
6073:
6074: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
6075: FND_MESSAGE.Set_Token('OBJECT_NAME', 'impl_rev_item_attr_changes'|| 'error code '||l_errorcode);
6076: FND_MSG_PUB.Add;
6077:
6078:
6079: FND_MSG_PUB.Count_And_Get
6101: ROLLBACK TO IMPL_REV_ITEM_USER_ATTR_CHGS;
6102: END IF;
6103:
6104:
6105: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
6106: FND_MESSAGE.Set_Token('OBJECT_NAME', 'ENG_IMPL_ITEM_CHANGES_PKG.impl_rev_item_attr_changes for ChangeId: '||l_change_id || '- ChangeLineId: '||l_change_line_id);
6107: FND_MSG_PUB.Add;
6108:
6109:
6102: END IF;
6103:
6104:
6105: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
6106: FND_MESSAGE.Set_Token('OBJECT_NAME', 'ENG_IMPL_ITEM_CHANGES_PKG.impl_rev_item_attr_changes for ChangeId: '||l_change_id || '- ChangeLineId: '||l_change_line_id);
6107: FND_MSG_PUB.Add;
6108:
6109:
6110: FND_MSG_PUB.Count_And_Get
6135:
6136:
6137: Write_Debug('When Others Exception ' || Substr(To_Char(SQLCODE)||'/'||SQLERRM,1,240));
6138:
6139: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
6140: FND_MESSAGE.Set_Token('OBJECT_NAME', 'ENG_IMPL_ITEM_CHANGES_PKG.impl_rev_item_attr_changes for ChangeId: '||l_change_id || '- ChangeLineId: '||l_change_line_id);
6141: FND_MSG_PUB.Add;
6142:
6143:
6136:
6137: Write_Debug('When Others Exception ' || Substr(To_Char(SQLCODE)||'/'||SQLERRM,1,240));
6138:
6139: FND_MESSAGE.Set_Name('ENG','ENG_ERROR_CALLING_PS_API');
6140: FND_MESSAGE.Set_Token('OBJECT_NAME', 'ENG_IMPL_ITEM_CHANGES_PKG.impl_rev_item_attr_changes for ChangeId: '||l_change_id || '- ChangeLineId: '||l_change_line_id);
6141: FND_MSG_PUB.Add;
6142:
6143:
6144: IF FND_MSG_PUB.Check_Msg_Level