APPS.AMS_APPROVAL_PVT dependencies on FND_MESSAGE

Line 277: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');

273: OPEN c_resource ;
274: FETCH c_resource INTO l_user, l_resource_name ;
275: IF c_resource%NOTFOUND THEN
276: CLOSE c_resource ;
277: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
278: Fnd_Message.Set_Token('ROW', SQLERRM );
279: Fnd_Msg_Pub.ADD;
280: x_return_status := Fnd_Api.G_RET_STS_ERROR;
281: RETURN;

Line 278: Fnd_Message.Set_Token('ROW', SQLERRM );

274: FETCH c_resource INTO l_user, l_resource_name ;
275: IF c_resource%NOTFOUND THEN
276: CLOSE c_resource ;
277: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
278: Fnd_Message.Set_Token('ROW', SQLERRM );
279: Fnd_Msg_Pub.ADD;
280: x_return_status := Fnd_Api.G_RET_STS_ERROR;
281: RETURN;
282: END IF;

Line 287: Fnd_Message.Set_Name('AMS','AMS_RESOURCE_HAS_NO_USER');

283: CLOSE c_resource ;
284:
285: -- Handle error when no user is associated with the approver's resource id.
286: IF l_user IS NULL THEN
287: Fnd_Message.Set_Name('AMS','AMS_RESOURCE_HAS_NO_USER');
288: Fnd_Message.Set_Token('RESOURCE', l_resource_name );
289: Fnd_Msg_Pub.ADD;
290: x_return_status := Fnd_Api.G_RET_STS_ERROR;
291: RETURN;

Line 288: Fnd_Message.Set_Token('RESOURCE', l_resource_name );

284:
285: -- Handle error when no user is associated with the approver's resource id.
286: IF l_user IS NULL THEN
287: Fnd_Message.Set_Name('AMS','AMS_RESOURCE_HAS_NO_USER');
288: Fnd_Message.Set_Token('RESOURCE', l_resource_name );
289: Fnd_Msg_Pub.ADD;
290: x_return_status := Fnd_Api.G_RET_STS_ERROR;
291: RETURN;
292: END IF;

Line 309: FND_MESSAGE.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');

305: p_attr => 'NOTE',
306: p_attr_defined_flag => 'Y'
307: );
308: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
309: FND_MESSAGE.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
310: FND_MESSAGE.Set_Token('ROW', SQLERRM );
311: FND_MSG_PUB.Add;
312: x_return_status := FND_API.G_RET_STS_ERROR;
313: return;

Line 310: FND_MESSAGE.Set_Token('ROW', SQLERRM );

306: p_attr_defined_flag => 'Y'
307: );
308: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
309: FND_MESSAGE.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
310: FND_MESSAGE.Set_Token('ROW', SQLERRM );
311: FND_MSG_PUB.Add;
312: x_return_status := FND_API.G_RET_STS_ERROR;
313: return;
314: END IF;

Line 334: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');

330: p_note_type => 'AMS_APPROVAL' ,
331: p_last_update_date => SYSDATE ,
332: p_creation_date => SYSDATE ) ;
333: IF x_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
334: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
335: Fnd_Message.Set_Token('ROW', SQLERRM );
336: Fnd_Msg_Pub.ADD;
337: x_return_status := Fnd_Api.G_RET_STS_ERROR;
338: RETURN;

Line 335: Fnd_Message.Set_Token('ROW', SQLERRM );

331: p_last_update_date => SYSDATE ,
332: p_creation_date => SYSDATE ) ;
333: IF x_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
334: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
335: Fnd_Message.Set_Token('ROW', SQLERRM );
336: Fnd_Msg_Pub.ADD;
337: x_return_status := Fnd_Api.G_RET_STS_ERROR;
338: RETURN;
339: END IF;

Line 384: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');

380: OPEN c_resource ;
381: FETCH c_resource INTO l_user ;
382: IF c_resource%NOTFOUND THEN
383: CLOSE c_resource ;
384: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
385: Fnd_Message.Set_Token('ROW', SQLERRM );
386: Fnd_Msg_Pub.ADD;
387: x_return_status := Fnd_Api.G_RET_STS_ERROR;
388: RETURN;

Line 385: Fnd_Message.Set_Token('ROW', SQLERRM );

381: FETCH c_resource INTO l_user ;
382: IF c_resource%NOTFOUND THEN
383: CLOSE c_resource ;
384: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
385: Fnd_Message.Set_Token('ROW', SQLERRM );
386: Fnd_Msg_Pub.ADD;
387: x_return_status := Fnd_Api.G_RET_STS_ERROR;
388: RETURN;
389: END IF;

Line 406: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');

402: p_attr => 'NOTE',
403: p_attr_defined_flag => 'Y'
404: );
405: IF x_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
406: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
407: Fnd_Message.Set_Token('ROW', SQLERRM );
408: Fnd_Msg_Pub.ADD;
409: x_return_status := Fnd_Api.G_RET_STS_ERROR;
410: RETURN;

Line 407: Fnd_Message.Set_Token('ROW', SQLERRM );

403: p_attr_defined_flag => 'Y'
404: );
405: IF x_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
406: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
407: Fnd_Message.Set_Token('ROW', SQLERRM );
408: Fnd_Msg_Pub.ADD;
409: x_return_status := Fnd_Api.G_RET_STS_ERROR;
410: RETURN;
411: END IF;

Line 430: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');

426: p_note_type => 'AMS_FREQ' ,
427: p_last_update_date => SYSDATE ,
428: p_creation_date => SYSDATE ) ;
429: IF x_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
430: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
431: Fnd_Message.Set_Token('ROW', SQLERRM );
432: Fnd_Msg_Pub.ADD;
433: x_return_status := Fnd_Api.G_RET_STS_ERROR;
434: RETURN;

Line 431: Fnd_Message.Set_Token('ROW', SQLERRM );

427: p_last_update_date => SYSDATE ,
428: p_creation_date => SYSDATE ) ;
429: IF x_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
430: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
431: Fnd_Message.Set_Token('ROW', SQLERRM );
432: Fnd_Msg_Pub.ADD;
433: x_return_status := Fnd_Api.G_RET_STS_ERROR;
434: RETURN;
435: END IF;

Line 481: Fnd_Message.Set_Name('AMS','AMS_APPR_INVALID_RESOURCE_ID');

477: FETCH c_resource INTO x_full_name ;
478: IF c_resource%NOTFOUND THEN
479: CLOSE c_resource ;
480: x_return_status := Fnd_Api.G_RET_STS_ERROR;
481: Fnd_Message.Set_Name('AMS','AMS_APPR_INVALID_RESOURCE_ID');
482: Fnd_Msg_Pub.ADD;
483: RETURN;
484: END IF;
485: CLOSE c_resource ;

Line 636: Fnd_Message.Set_Name('AMS','AMS_APPR_INVALID_RESOURCE_ID');

632: FETCH c_resource INTO l_person_id , l_user_id, l_category;
633: IF c_resource%NOTFOUND THEN
634: CLOSE c_resource ;
635: x_return_status := Fnd_Api.G_RET_STS_ERROR;
636: Fnd_Message.Set_Name('AMS','AMS_APPR_INVALID_RESOURCE_ID');
637: Fnd_Msg_Pub.ADD;
638: RETURN;
639: END IF;
640: CLOSE c_resource ;

Line 650: Fnd_Message.Set_Name('AMS','AMS_APPR_INVALID_ROLE');

646: p_name => x_role_name,
647: p_display_name => x_role_display_name );
648: IF x_role_name IS NULL THEN
649: x_return_status := Fnd_Api.G_RET_STS_ERROR;
650: Fnd_Message.Set_Name('AMS','AMS_APPR_INVALID_ROLE');
651: Fnd_Msg_Pub.ADD;
652: RETURN;
653: END IF;
654: ELSE

Line 662: Fnd_Message.Set_Name('AMS','AMS_APPR_INVALID_ROLE');

658: p_name => x_role_name,
659: p_display_name => x_role_display_name );
660: IF x_role_name IS NULL THEN
661: x_return_status := Fnd_Api.G_RET_STS_ERROR;
662: Fnd_Message.Set_Name('AMS','AMS_APPR_INVALID_ROLE');
663: Fnd_Msg_Pub.ADD;
664: RETURN;
665: END IF;
666: END IF;

Line 892: Fnd_Message.Set_Name('AMS','AMS_BAD_APPROVAL_OBJECT_TYPE');

888: '' parent_name
889: FROM ams_deliverables_vl
890: WHERE deliverable_id = p_activity_id;
891: ELSE
892: Fnd_Message.Set_Name('AMS','AMS_BAD_APPROVAL_OBJECT_TYPE');
893: Fnd_Msg_Pub.ADD;
894: x_return_status := Fnd_Api.G_RET_STS_ERROR;
895: RETURN;
896: END IF ;

Line 901: Fnd_Message.Set_Name('AMS','AMS_APPR_BAD_DETAILS');

897:
898: FETCH l_obj_details INTO x_object_details;
899: IF l_obj_details%NOTFOUND THEN
900: CLOSE l_obj_details;
901: Fnd_Message.Set_Name('AMS','AMS_APPR_BAD_DETAILS');
902: Fnd_Msg_Pub.ADD;
903: x_return_status := Fnd_Api.G_RET_STS_ERROR;
904: RETURN;
905: END IF;

Line 920: Fnd_Message.set_name('AMS', 'AMS_BAD_PRIORITY');

916: );
917:
918: IF x_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
919: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
920: Fnd_Message.set_name('AMS', 'AMS_BAD_PRIORITY');
921: Fnd_Msg_Pub.ADD;
922: x_return_status := Fnd_Api.G_RET_STS_ERROR;
923: RETURN;
924: END IF;

Line 1182: Fnd_Message.Set_Name('AMS','AMS_NO_APPR_FOR_RULE');

1178:
1179: OPEN c_rule_name;
1180: FETCH c_rule_name INTO l_rule_name;
1181: CLOSE c_rule_name;
1182: Fnd_Message.Set_Name('AMS','AMS_NO_APPR_FOR_RULE');
1183: Fnd_Message.Set_Token('RULE_NAME',l_rule_name);
1184: Fnd_Msg_Pub.ADD;
1185: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1186: RETURN;

Line 1183: Fnd_Message.Set_Token('RULE_NAME',l_rule_name);

1179: OPEN c_rule_name;
1180: FETCH c_rule_name INTO l_rule_name;
1181: CLOSE c_rule_name;
1182: Fnd_Message.Set_Name('AMS','AMS_NO_APPR_FOR_RULE');
1183: Fnd_Message.Set_Token('RULE_NAME',l_rule_name);
1184: Fnd_Msg_Pub.ADD;
1185: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1186: RETURN;
1187: END IF;

Line 1195: Fnd_Message.Set_Name('AMS','AMS_NO_DEFAULT_ROLE'); -- VMODUR added

1191: OPEN c_default_role_info ;
1192: FETCH c_default_role_info INTO x_object_approver_id;
1193: IF c_default_role_info%NOTFOUND THEN
1194: CLOSE c_default_role_info ;
1195: Fnd_Message.Set_Name('AMS','AMS_NO_DEFAULT_ROLE'); -- VMODUR added
1196: --Fnd_Message.Set_Name('AMS','AMS_APPR_INVALID_ROLE');
1197: Fnd_Msg_Pub.ADD;
1198: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1199: RETURN;

Line 1196: --Fnd_Message.Set_Name('AMS','AMS_APPR_INVALID_ROLE');

1192: FETCH c_default_role_info INTO x_object_approver_id;
1193: IF c_default_role_info%NOTFOUND THEN
1194: CLOSE c_default_role_info ;
1195: Fnd_Message.Set_Name('AMS','AMS_NO_DEFAULT_ROLE'); -- VMODUR added
1196: --Fnd_Message.Set_Name('AMS','AMS_APPR_INVALID_ROLE');
1197: Fnd_Msg_Pub.ADD;
1198: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1199: RETURN;
1200: END IF;

Line 1208: Fnd_Message.Set_Name('AMS','AMS_MANY_DEFAULT_ROLE'); -- VMODUR added

1204: OPEN c_role_info_count;
1205: FETCH c_role_info_count INTO l_count;
1206: IF l_count > 1 THEN
1207: CLOSE c_role_info_count;
1208: Fnd_Message.Set_Name('AMS','AMS_MANY_DEFAULT_ROLE'); -- VMODUR added
1209: --Fnd_Message.Set_Name('AMS','AMS_APPR_INVALID_ROLE');
1210: Fnd_Msg_Pub.ADD;
1211: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1212: RETURN;

Line 1209: --Fnd_Message.Set_Name('AMS','AMS_APPR_INVALID_ROLE');

1205: FETCH c_role_info_count INTO l_count;
1206: IF l_count > 1 THEN
1207: CLOSE c_role_info_count;
1208: Fnd_Message.Set_Name('AMS','AMS_MANY_DEFAULT_ROLE'); -- VMODUR added
1209: --Fnd_Message.Set_Name('AMS','AMS_APPR_INVALID_ROLE');
1210: Fnd_Msg_Pub.ADD;
1211: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1212: RETURN;
1213: END IF;

Line 1219: Fnd_Message.Set_Name('AMS','AMS_APPR_INVALID_ROLE');

1215: OPEN c_role_info;
1216: FETCH c_role_info INTO x_object_approver_id, x_role_name;
1217: IF c_role_info%NOTFOUND THEN
1218: CLOSE c_role_info;
1219: Fnd_Message.Set_Name('AMS','AMS_APPR_INVALID_ROLE');
1220: Fnd_Msg_Pub.ADD;
1221: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1222: RETURN;
1223: END IF;

Line 1529: FND_MESSAGE.Set_Name('AMS','AMS_NO_DEFAULT_ROLE');

1525: OPEN c_approver_def ;
1526: FETCH c_approver_def INTO x_approval_detail_id;
1527: IF c_approver_def%NOTFOUND THEN
1528: CLOSE c_approver_def ;
1529: FND_MESSAGE.Set_Name('AMS','AMS_NO_DEFAULT_ROLE');
1530: FND_MSG_PUB.Add;
1531: x_return_status := FND_API.G_RET_STS_ERROR;
1532: return;
1533: END IF;

Line 1599: FND_MESSAGE.Set_Name('AMS','AMS_NO_DEFAULT_ROLE');

1595: OPEN c_approver_def ;
1596: FETCH c_approver_def INTO x_approval_detail_id;
1597: IF c_approver_def%NOTFOUND THEN
1598: CLOSE c_approver_def ;
1599: FND_MESSAGE.Set_Name('AMS','AMS_NO_DEFAULT_ROLE');
1600: FND_MSG_PUB.Add;
1601: x_return_status := FND_API.G_RET_STS_ERROR;
1602: return;
1603: END IF;

Line 1613: FND_MESSAGE.Set_Name('AMS','AMS_NO_APPROVER_SEQUENCE');

1609: OPEN c_approver_seq ;
1610: FETCH c_approver_seq INTO x_approver_seq ;
1611: IF c_approver_seq%NOTFOUND THEN
1612: CLOSE c_approver_seq;
1613: FND_MESSAGE.Set_Name('AMS','AMS_NO_APPROVER_SEQUENCE');
1614: FND_MSG_PUB.Add;
1615: x_return_status := FND_API.G_RET_STS_ERROR;
1616: return;
1617: END IF;

Line 1845: Fnd_Message.Set_Name('AMS','AMS_BAD_APPROVAL_OBJECT_TYPE');

1841: l_return_status,
1842: l_appr_meaning
1843: );
1844: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
1845: Fnd_Message.Set_Name('AMS','AMS_BAD_APPROVAL_OBJECT_TYPE');
1846: Fnd_Msg_Pub.ADD;
1847: RAISE Fnd_Api.G_EXC_ERROR;
1848: END IF;
1849:

Line 4214: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');

4210: x_approver_seq => l_approver_seq,
4211: x_return_status => l_return_status );
4212: EXCEPTION
4213: WHEN OTHERS THEN
4214: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
4215: Fnd_Message.Set_Token('ROW', SQLERRM );
4216: Fnd_Msg_Pub.ADD;
4217: RAISE Fnd_Api.G_EXC_ERROR;
4218: END;

Line 4215: Fnd_Message.Set_Token('ROW', SQLERRM );

4211: x_return_status => l_return_status );
4212: EXCEPTION
4213: WHEN OTHERS THEN
4214: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
4215: Fnd_Message.Set_Token('ROW', SQLERRM );
4216: Fnd_Msg_Pub.ADD;
4217: RAISE Fnd_Api.G_EXC_ERROR;
4218: END;
4219:

Line 4372: Fnd_Message.set_name('AMS', 'AMS_BUDGET_LINE_START_ERROR');

4368: EXCEPTION
4369: WHEN Fnd_Api.G_EXC_ERROR THEN
4370: -- raise error if not able to get the budget line
4371: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
4372: Fnd_Message.set_name('AMS', 'AMS_BUDGET_LINE_START_ERROR');
4373: Fnd_Msg_Pub.ADD;
4374: END IF;
4375:
4376: Fnd_Msg_Pub.Count_And_Get (

Line 4476: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');

4472: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
4473: END IF;
4474: -- Debug Message
4475: IF Fnd_Msg_Pub.Check_Msg_level (Fnd_Msg_Pub.G_MSG_LVL_DEBUG_LOW) THEN
4476: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
4477: Fnd_Message.Set_Token('ROW',l_full_name||': START');
4478: Fnd_Msg_Pub.ADD;
4479: END IF;
4480: --Initialize message list if p_init_msg_list is TRUE.

Line 4477: Fnd_Message.Set_Token('ROW',l_full_name||': START');

4473: END IF;
4474: -- Debug Message
4475: IF Fnd_Msg_Pub.Check_Msg_level (Fnd_Msg_Pub.G_MSG_LVL_DEBUG_LOW) THEN
4476: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
4477: Fnd_Message.Set_Token('ROW',l_full_name||': START');
4478: Fnd_Msg_Pub.ADD;
4479: END IF;
4480: --Initialize message list if p_init_msg_list is TRUE.
4481: IF Fnd_Api.To_Boolean (p_init_msg_list) THEN

Line 4502: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');

4498: p_parent_approval_flag => p_parent_approval_flag,
4499: p_continue_flow => p_continue_flow );
4500: EXCEPTION
4501: WHEN OTHERS THEN
4502: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
4503: Fnd_Message.Set_Token('ROW',SQLERRM);
4504: Fnd_Msg_Pub.ADD;
4505: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
4506: END;

Line 4503: Fnd_Message.Set_Token('ROW',SQLERRM);

4499: p_continue_flow => p_continue_flow );
4500: EXCEPTION
4501: WHEN OTHERS THEN
4502: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
4503: Fnd_Message.Set_Token('ROW',SQLERRM);
4504: Fnd_Msg_Pub.ADD;
4505: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
4506: END;
4507:

Line 4514: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');

4510: COMMIT WORK;
4511: END IF;
4512: -- Debug Message
4513: IF Fnd_Msg_Pub.Check_Msg_level (Fnd_Msg_Pub.G_MSG_LVL_DEBUG_LOW) THEN
4514: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
4515: Fnd_Message.Set_Token('ROW',l_full_name||': END');
4516: Fnd_Msg_Pub.ADD;
4517: END IF;
4518: --Standard call to get message count and if count=1, get the message

Line 4515: Fnd_Message.Set_Token('ROW',l_full_name||': END');

4511: END IF;
4512: -- Debug Message
4513: IF Fnd_Msg_Pub.Check_Msg_level (Fnd_Msg_Pub.G_MSG_LVL_DEBUG_LOW) THEN
4514: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
4515: Fnd_Message.Set_Token('ROW',l_full_name||': END');
4516: Fnd_Msg_Pub.ADD;
4517: END IF;
4518: --Standard call to get message count and if count=1, get the message
4519: Fnd_Msg_Pub.Count_And_Get (

Line 4710: --Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');

4706:
4707: EXCEPTION
4708: WHEN OTHERS THEN
4709: -- Commented for Bug 2485371
4710: --Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
4711: --Fnd_Message.Set_Token('ROW', SQLERRM );
4712: --Fnd_Msg_Pub.ADD;
4713: RAISE Fnd_Api.G_EXC_ERROR;
4714: Fnd_Msg_Pub.Count_And_Get (

Line 4711: --Fnd_Message.Set_Token('ROW', SQLERRM );

4707: EXCEPTION
4708: WHEN OTHERS THEN
4709: -- Commented for Bug 2485371
4710: --Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
4711: --Fnd_Message.Set_Token('ROW', SQLERRM );
4712: --Fnd_Msg_Pub.ADD;
4713: RAISE Fnd_Api.G_EXC_ERROR;
4714: Fnd_Msg_Pub.Count_And_Get (
4715: p_encoded => Fnd_Api.G_FALSE,

Line 4758: -- Fnd_Message.set_name('AMS', 'AMS_BUDGET_LINE_UPDATE_ERROR');

4754: WHEN Fnd_Api.G_EXC_ERROR THEN
4755: -- raise error if not able to get the budget line
4756: -- Commented for Bug 2485371
4757: --IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
4758: -- Fnd_Message.set_name('AMS', 'AMS_BUDGET_LINE_UPDATE_ERROR');
4759: -- Fnd_Msg_Pub.ADD;
4760: --END IF;
4761: Fnd_Msg_Pub.Count_And_Get (
4762: p_encoded => Fnd_Api.G_FALSE,

Line 5403: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');

5399: itemtype, itemkey,TO_CHAR(actid),l_error_msg);
5400: RAISE;
5401: WHEN OTHERS THEN
5402: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
5403: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
5404: Fnd_Message.Set_Token('ROW',SQLERRM);
5405: Fnd_Msg_Pub.ADD;
5406: END IF;
5407: Fnd_Msg_Pub.Count_And_Get (

Line 5404: Fnd_Message.Set_Token('ROW',SQLERRM);

5400: RAISE;
5401: WHEN OTHERS THEN
5402: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
5403: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
5404: Fnd_Message.Set_Token('ROW',SQLERRM);
5405: Fnd_Msg_Pub.ADD;
5406: END IF;
5407: Fnd_Msg_Pub.Count_And_Get (
5408: p_encoded => Fnd_Api.G_FALSE,

Line 5569: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');

5565:
5566: END IF;
5567: EXCEPTION
5568: WHEN OTHERS THEN
5569: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
5570: Fnd_Message.Set_Token('ROW', SQLERRM );
5571: Fnd_Msg_Pub.ADD;
5572: RAISE Fnd_Api.G_EXC_ERROR;
5573: END;

Line 5570: Fnd_Message.Set_Token('ROW', SQLERRM );

5566: END IF;
5567: EXCEPTION
5568: WHEN OTHERS THEN
5569: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
5570: Fnd_Message.Set_Token('ROW', SQLERRM );
5571: Fnd_Msg_Pub.ADD;
5572: RAISE Fnd_Api.G_EXC_ERROR;
5573: END;
5574:

Line 5795: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');

5791: END IF;
5792:
5793: EXCEPTION
5794: WHEN OTHERS THEN
5795: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
5796: Fnd_Message.Set_Token('ROW', SQLERRM );
5797: Fnd_Msg_Pub.ADD;
5798: RAISE Fnd_Api.G_EXC_ERROR;
5799: END;

Line 5796: Fnd_Message.Set_Token('ROW', SQLERRM );

5792:
5793: EXCEPTION
5794: WHEN OTHERS THEN
5795: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
5796: Fnd_Message.Set_Token('ROW', SQLERRM );
5797: Fnd_Msg_Pub.ADD;
5798: RAISE Fnd_Api.G_EXC_ERROR;
5799: END;
5800: -- Commented for bug 3150550

Line 6026: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');

6022: p_approved_currency => l_approved_currency,
6023: p_comment => l_comment);
6024:
6025: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
6026: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
6027: --Fnd_Message.Set_Token('ROW', SQLERRM );
6028: Fnd_Msg_Pub.ADD;
6029:
6030: Fnd_Msg_Pub.Count_And_Get (

Line 6027: --Fnd_Message.Set_Token('ROW', SQLERRM );

6023: p_comment => l_comment);
6024:
6025: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
6026: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
6027: --Fnd_Message.Set_Token('ROW', SQLERRM );
6028: Fnd_Msg_Pub.ADD;
6029:
6030: Fnd_Msg_Pub.Count_And_Get (
6031: p_encoded => Fnd_Api.G_FALSE,

Line 6048: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');

6044: END IF;
6045:
6046: EXCEPTION
6047: WHEN OTHERS THEN
6048: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
6049: Fnd_Message.Set_Token('ROW', SQLERRM );
6050: Fnd_Msg_Pub.ADD;
6051: RAISE Fnd_Api.G_EXC_ERROR;
6052: END;

Line 6049: Fnd_Message.Set_Token('ROW', SQLERRM );

6045:
6046: EXCEPTION
6047: WHEN OTHERS THEN
6048: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
6049: Fnd_Message.Set_Token('ROW', SQLERRM );
6050: Fnd_Msg_Pub.ADD;
6051: RAISE Fnd_Api.G_EXC_ERROR;
6052: END;
6053:

Line 6211: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');

6207:
6208: EXCEPTION
6209: WHEN OTHERS THEN
6210: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
6211: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
6212: Fnd_Message.Set_Token('ROW',SQLERRM);
6213: Fnd_Msg_Pub.ADD;
6214: END IF;
6215: Fnd_Msg_Pub.Count_And_Get (

Line 6212: Fnd_Message.Set_Token('ROW',SQLERRM);

6208: EXCEPTION
6209: WHEN OTHERS THEN
6210: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
6211: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
6212: Fnd_Message.Set_Token('ROW',SQLERRM);
6213: Fnd_Msg_Pub.ADD;
6214: END IF;
6215: Fnd_Msg_Pub.Count_And_Get (
6216: p_encoded => Fnd_Api.G_FALSE,

Line 6359: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');

6355:
6356: EXCEPTION
6357: WHEN OTHERS THEN
6358: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
6359: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
6360: Fnd_Message.Set_Token('ROW',SQLERRM);
6361: Fnd_Msg_Pub.ADD;
6362: END IF;
6363: Fnd_Msg_Pub.Count_And_Get (

Line 6360: Fnd_Message.Set_Token('ROW',SQLERRM);

6356: EXCEPTION
6357: WHEN OTHERS THEN
6358: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
6359: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
6360: Fnd_Message.Set_Token('ROW',SQLERRM);
6361: Fnd_Msg_Pub.ADD;
6362: END IF;
6363: Fnd_Msg_Pub.Count_And_Get (
6364: p_encoded => Fnd_Api.G_FALSE,

Line 6489: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');

6485:
6486: EXCEPTION
6487: WHEN OTHERS THEN
6488: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
6489: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
6490: Fnd_Message.Set_Token('ROW',SQLERRM);
6491: Fnd_Msg_Pub.ADD;
6492: END IF;
6493: Fnd_Msg_Pub.Count_And_Get (

Line 6490: Fnd_Message.Set_Token('ROW',SQLERRM);

6486: EXCEPTION
6487: WHEN OTHERS THEN
6488: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
6489: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
6490: Fnd_Message.Set_Token('ROW',SQLERRM);
6491: Fnd_Msg_Pub.ADD;
6492: END IF;
6493: Fnd_Msg_Pub.Count_And_Get (
6494: p_encoded => Fnd_Api.G_FALSE,

Line 6640: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');

6636:
6637: EXCEPTION
6638: WHEN OTHERS THEN
6639: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
6640: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
6641: Fnd_Message.Set_Token('ROW',SQLERRM);
6642: Fnd_Msg_Pub.ADD;
6643: END IF;
6644: Fnd_Msg_Pub.Count_And_Get (

Line 6641: Fnd_Message.Set_Token('ROW',SQLERRM);

6637: EXCEPTION
6638: WHEN OTHERS THEN
6639: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
6640: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
6641: Fnd_Message.Set_Token('ROW',SQLERRM);
6642: Fnd_Msg_Pub.ADD;
6643: END IF;
6644: Fnd_Msg_Pub.Count_And_Get (
6645: p_encoded => Fnd_Api.G_FALSE,

Line 6743: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');

6739:
6740: EXCEPTION
6741: WHEN OTHERS THEN
6742: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
6743: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
6744: Fnd_Message.Set_Token('ROW',SQLERRM);
6745: Fnd_Msg_Pub.ADD;
6746: END IF;
6747: Fnd_Msg_Pub.Count_And_Get (

Line 6744: Fnd_Message.Set_Token('ROW',SQLERRM);

6740: EXCEPTION
6741: WHEN OTHERS THEN
6742: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
6743: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
6744: Fnd_Message.Set_Token('ROW',SQLERRM);
6745: Fnd_Msg_Pub.ADD;
6746: END IF;
6747: Fnd_Msg_Pub.Count_And_Get (
6748: p_encoded => Fnd_Api.G_FALSE,