APPS.AMS_APPROVAL_PVT dependencies on FND_MESSAGE

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

238: OPEN c_resource ;
239: FETCH c_resource INTO l_user, l_resource_name ;
240: IF c_resource%NOTFOUND THEN
241: CLOSE c_resource ;
242: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
243: Fnd_Message.Set_Token('ROW', SQLERRM );
244: Fnd_Msg_Pub.ADD;
245: x_return_status := Fnd_Api.G_RET_STS_ERROR;
246: RETURN;

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

239: FETCH c_resource INTO l_user, l_resource_name ;
240: IF c_resource%NOTFOUND THEN
241: CLOSE c_resource ;
242: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
243: Fnd_Message.Set_Token('ROW', SQLERRM );
244: Fnd_Msg_Pub.ADD;
245: x_return_status := Fnd_Api.G_RET_STS_ERROR;
246: RETURN;
247: END IF;

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

248: CLOSE c_resource ;
249:
250: -- Handle error when no user is associated with the approver's resource id.
251: IF l_user IS NULL THEN
252: Fnd_Message.Set_Name('AMS','AMS_RESOURCE_HAS_NO_USER');
253: Fnd_Message.Set_Token('RESOURCE', l_resource_name );
254: Fnd_Msg_Pub.ADD;
255: x_return_status := Fnd_Api.G_RET_STS_ERROR;
256: RETURN;

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

249:
250: -- Handle error when no user is associated with the approver's resource id.
251: IF l_user IS NULL THEN
252: Fnd_Message.Set_Name('AMS','AMS_RESOURCE_HAS_NO_USER');
253: Fnd_Message.Set_Token('RESOURCE', l_resource_name );
254: Fnd_Msg_Pub.ADD;
255: x_return_status := Fnd_Api.G_RET_STS_ERROR;
256: RETURN;
257: END IF;

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

270: p_attr => 'NOTE',
271: p_attr_defined_flag => 'Y'
272: );
273: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
274: FND_MESSAGE.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
275: FND_MESSAGE.Set_Token('ROW', SQLERRM );
276: FND_MSG_PUB.Add;
277: x_return_status := FND_API.G_RET_STS_ERROR;
278: return;

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

271: p_attr_defined_flag => 'Y'
272: );
273: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
274: FND_MESSAGE.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
275: FND_MESSAGE.Set_Token('ROW', SQLERRM );
276: FND_MSG_PUB.Add;
277: x_return_status := FND_API.G_RET_STS_ERROR;
278: return;
279: END IF;

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

295: p_note_type => 'AMS_APPROVAL' ,
296: p_last_update_date => SYSDATE ,
297: p_creation_date => SYSDATE ) ;
298: IF x_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
299: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
300: Fnd_Message.Set_Token('ROW', SQLERRM );
301: Fnd_Msg_Pub.ADD;
302: x_return_status := Fnd_Api.G_RET_STS_ERROR;
303: RETURN;

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

296: p_last_update_date => SYSDATE ,
297: p_creation_date => SYSDATE ) ;
298: IF x_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
299: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
300: Fnd_Message.Set_Token('ROW', SQLERRM );
301: Fnd_Msg_Pub.ADD;
302: x_return_status := Fnd_Api.G_RET_STS_ERROR;
303: RETURN;
304: END IF;

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

345: OPEN c_resource ;
346: FETCH c_resource INTO l_user ;
347: IF c_resource%NOTFOUND THEN
348: CLOSE c_resource ;
349: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
350: Fnd_Message.Set_Token('ROW', SQLERRM );
351: Fnd_Msg_Pub.ADD;
352: x_return_status := Fnd_Api.G_RET_STS_ERROR;
353: RETURN;

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

346: FETCH c_resource INTO l_user ;
347: IF c_resource%NOTFOUND THEN
348: CLOSE c_resource ;
349: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
350: Fnd_Message.Set_Token('ROW', SQLERRM );
351: Fnd_Msg_Pub.ADD;
352: x_return_status := Fnd_Api.G_RET_STS_ERROR;
353: RETURN;
354: END IF;

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

367: p_attr => 'NOTE',
368: p_attr_defined_flag => 'Y'
369: );
370: IF x_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
371: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
372: Fnd_Message.Set_Token('ROW', SQLERRM );
373: Fnd_Msg_Pub.ADD;
374: x_return_status := Fnd_Api.G_RET_STS_ERROR;
375: RETURN;

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

368: p_attr_defined_flag => 'Y'
369: );
370: IF x_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
371: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
372: Fnd_Message.Set_Token('ROW', SQLERRM );
373: Fnd_Msg_Pub.ADD;
374: x_return_status := Fnd_Api.G_RET_STS_ERROR;
375: RETURN;
376: END IF;

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

391: p_note_type => 'AMS_FREQ' ,
392: p_last_update_date => SYSDATE ,
393: p_creation_date => SYSDATE ) ;
394: IF x_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
395: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
396: Fnd_Message.Set_Token('ROW', SQLERRM );
397: Fnd_Msg_Pub.ADD;
398: x_return_status := Fnd_Api.G_RET_STS_ERROR;
399: RETURN;

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

392: p_last_update_date => SYSDATE ,
393: p_creation_date => SYSDATE ) ;
394: IF x_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
395: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
396: Fnd_Message.Set_Token('ROW', SQLERRM );
397: Fnd_Msg_Pub.ADD;
398: x_return_status := Fnd_Api.G_RET_STS_ERROR;
399: RETURN;
400: END IF;

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

442: FETCH c_resource INTO x_full_name ;
443: IF c_resource%NOTFOUND THEN
444: CLOSE c_resource ;
445: x_return_status := Fnd_Api.G_RET_STS_ERROR;
446: Fnd_Message.Set_Name('AMS','AMS_APPR_INVALID_RESOURCE_ID');
447: Fnd_Msg_Pub.ADD;
448: RETURN;
449: END IF;
450: CLOSE c_resource ;

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

597: FETCH c_resource INTO l_person_id , l_user_id, l_category;
598: IF c_resource%NOTFOUND THEN
599: CLOSE c_resource ;
600: x_return_status := Fnd_Api.G_RET_STS_ERROR;
601: Fnd_Message.Set_Name('AMS','AMS_APPR_INVALID_RESOURCE_ID');
602: Fnd_Msg_Pub.ADD;
603: RETURN;
604: END IF;
605: CLOSE c_resource ;

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

611: p_name => x_role_name,
612: p_display_name => x_role_display_name );
613: IF x_role_name IS NULL THEN
614: x_return_status := Fnd_Api.G_RET_STS_ERROR;
615: Fnd_Message.Set_Name('AMS','AMS_APPR_INVALID_ROLE');
616: Fnd_Msg_Pub.ADD;
617: RETURN;
618: END IF;
619: ELSE

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

623: p_name => x_role_name,
624: p_display_name => x_role_display_name );
625: IF x_role_name IS NULL THEN
626: x_return_status := Fnd_Api.G_RET_STS_ERROR;
627: Fnd_Message.Set_Name('AMS','AMS_APPR_INVALID_ROLE');
628: Fnd_Msg_Pub.ADD;
629: RETURN;
630: END IF;
631: END IF;

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

852: '' parent_name
853: FROM ams_deliverables_vl
854: WHERE deliverable_id = p_activity_id;
855: ELSE
856: Fnd_Message.Set_Name('AMS','AMS_BAD_APPROVAL_OBJECT_TYPE');
857: Fnd_Msg_Pub.ADD;
858: x_return_status := Fnd_Api.G_RET_STS_ERROR;
859: RETURN;
860: END IF ;

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

861:
862: FETCH l_obj_details INTO x_object_details;
863: IF l_obj_details%NOTFOUND THEN
864: CLOSE l_obj_details;
865: Fnd_Message.Set_Name('AMS','AMS_APPR_BAD_DETAILS');
866: Fnd_Msg_Pub.ADD;
867: x_return_status := Fnd_Api.G_RET_STS_ERROR;
868: RETURN;
869: END IF;

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

880: );
881:
882: IF x_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
883: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
884: Fnd_Message.set_name('AMS', 'AMS_BAD_PRIORITY');
885: Fnd_Msg_Pub.ADD;
886: x_return_status := Fnd_Api.G_RET_STS_ERROR;
887: RETURN;
888: END IF;

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

1142:
1143: OPEN c_rule_name;
1144: FETCH c_rule_name INTO l_rule_name;
1145: CLOSE c_rule_name;
1146: Fnd_Message.Set_Name('AMS','AMS_NO_APPR_FOR_RULE');
1147: Fnd_Message.Set_Token('RULE_NAME',l_rule_name);
1148: Fnd_Msg_Pub.ADD;
1149: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1150: RETURN;

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

1143: OPEN c_rule_name;
1144: FETCH c_rule_name INTO l_rule_name;
1145: CLOSE c_rule_name;
1146: Fnd_Message.Set_Name('AMS','AMS_NO_APPR_FOR_RULE');
1147: Fnd_Message.Set_Token('RULE_NAME',l_rule_name);
1148: Fnd_Msg_Pub.ADD;
1149: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1150: RETURN;
1151: END IF;

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

1155: OPEN c_default_role_info ;
1156: FETCH c_default_role_info INTO x_object_approver_id;
1157: IF c_default_role_info%NOTFOUND THEN
1158: CLOSE c_default_role_info ;
1159: Fnd_Message.Set_Name('AMS','AMS_NO_DEFAULT_ROLE'); -- VMODUR added
1160: --Fnd_Message.Set_Name('AMS','AMS_APPR_INVALID_ROLE');
1161: Fnd_Msg_Pub.ADD;
1162: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1163: RETURN;

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

1156: FETCH c_default_role_info INTO x_object_approver_id;
1157: IF c_default_role_info%NOTFOUND THEN
1158: CLOSE c_default_role_info ;
1159: Fnd_Message.Set_Name('AMS','AMS_NO_DEFAULT_ROLE'); -- VMODUR added
1160: --Fnd_Message.Set_Name('AMS','AMS_APPR_INVALID_ROLE');
1161: Fnd_Msg_Pub.ADD;
1162: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1163: RETURN;
1164: END IF;

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

1168: OPEN c_role_info_count;
1169: FETCH c_role_info_count INTO l_count;
1170: IF l_count > 1 THEN
1171: CLOSE c_role_info_count;
1172: Fnd_Message.Set_Name('AMS','AMS_MANY_DEFAULT_ROLE'); -- VMODUR added
1173: --Fnd_Message.Set_Name('AMS','AMS_APPR_INVALID_ROLE');
1174: Fnd_Msg_Pub.ADD;
1175: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1176: RETURN;

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

1169: FETCH c_role_info_count INTO l_count;
1170: IF l_count > 1 THEN
1171: CLOSE c_role_info_count;
1172: Fnd_Message.Set_Name('AMS','AMS_MANY_DEFAULT_ROLE'); -- VMODUR added
1173: --Fnd_Message.Set_Name('AMS','AMS_APPR_INVALID_ROLE');
1174: Fnd_Msg_Pub.ADD;
1175: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1176: RETURN;
1177: END IF;

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

1179: OPEN c_role_info;
1180: FETCH c_role_info INTO x_object_approver_id, x_role_name;
1181: IF c_role_info%NOTFOUND THEN
1182: CLOSE c_role_info;
1183: Fnd_Message.Set_Name('AMS','AMS_APPR_INVALID_ROLE');
1184: Fnd_Msg_Pub.ADD;
1185: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1186: RETURN;
1187: END IF;

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

1489: OPEN c_approver_def ;
1490: FETCH c_approver_def INTO x_approval_detail_id;
1491: IF c_approver_def%NOTFOUND THEN
1492: CLOSE c_approver_def ;
1493: FND_MESSAGE.Set_Name('AMS','AMS_NO_DEFAULT_ROLE');
1494: FND_MSG_PUB.Add;
1495: x_return_status := FND_API.G_RET_STS_ERROR;
1496: return;
1497: END IF;

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

1559: OPEN c_approver_def ;
1560: FETCH c_approver_def INTO x_approval_detail_id;
1561: IF c_approver_def%NOTFOUND THEN
1562: CLOSE c_approver_def ;
1563: FND_MESSAGE.Set_Name('AMS','AMS_NO_DEFAULT_ROLE');
1564: FND_MSG_PUB.Add;
1565: x_return_status := FND_API.G_RET_STS_ERROR;
1566: return;
1567: END IF;

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

1573: OPEN c_approver_seq ;
1574: FETCH c_approver_seq INTO x_approver_seq ;
1575: IF c_approver_seq%NOTFOUND THEN
1576: CLOSE c_approver_seq;
1577: FND_MESSAGE.Set_Name('AMS','AMS_NO_APPROVER_SEQUENCE');
1578: FND_MSG_PUB.Add;
1579: x_return_status := FND_API.G_RET_STS_ERROR;
1580: return;
1581: END IF;

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

1805: l_return_status,
1806: l_appr_meaning
1807: );
1808: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
1809: Fnd_Message.Set_Name('AMS','AMS_BAD_APPROVAL_OBJECT_TYPE');
1810: Fnd_Msg_Pub.ADD;
1811: RAISE Fnd_Api.G_EXC_ERROR;
1812: END IF;
1813:

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

4119: x_approver_seq => l_approver_seq,
4120: x_return_status => l_return_status );
4121: EXCEPTION
4122: WHEN OTHERS THEN
4123: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
4124: Fnd_Message.Set_Token('ROW', SQLERRM );
4125: Fnd_Msg_Pub.ADD;
4126: RAISE Fnd_Api.G_EXC_ERROR;
4127: END;

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

4120: x_return_status => l_return_status );
4121: EXCEPTION
4122: WHEN OTHERS THEN
4123: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
4124: Fnd_Message.Set_Token('ROW', SQLERRM );
4125: Fnd_Msg_Pub.ADD;
4126: RAISE Fnd_Api.G_EXC_ERROR;
4127: END;
4128:

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

4277: EXCEPTION
4278: WHEN Fnd_Api.G_EXC_ERROR THEN
4279: -- raise error if not able to get the budget line
4280: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
4281: Fnd_Message.set_name('AMS', 'AMS_BUDGET_LINE_START_ERROR');
4282: Fnd_Msg_Pub.ADD;
4283: END IF;
4284:
4285: Fnd_Msg_Pub.Count_And_Get (

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

4381: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
4382: END IF;
4383: -- Debug Message
4384: IF Fnd_Msg_Pub.Check_Msg_level (Fnd_Msg_Pub.G_MSG_LVL_DEBUG_LOW) THEN
4385: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
4386: Fnd_Message.Set_Token('ROW',l_full_name||': START');
4387: Fnd_Msg_Pub.ADD;
4388: END IF;
4389: --Initialize message list if p_init_msg_list is TRUE.

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

4382: END IF;
4383: -- Debug Message
4384: IF Fnd_Msg_Pub.Check_Msg_level (Fnd_Msg_Pub.G_MSG_LVL_DEBUG_LOW) THEN
4385: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
4386: Fnd_Message.Set_Token('ROW',l_full_name||': START');
4387: Fnd_Msg_Pub.ADD;
4388: END IF;
4389: --Initialize message list if p_init_msg_list is TRUE.
4390: IF Fnd_Api.To_Boolean (p_init_msg_list) THEN

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

4407: p_parent_approval_flag => p_parent_approval_flag,
4408: p_continue_flow => p_continue_flow );
4409: EXCEPTION
4410: WHEN OTHERS THEN
4411: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
4412: Fnd_Message.Set_Token('ROW',SQLERRM);
4413: Fnd_Msg_Pub.ADD;
4414: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
4415: END;

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

4408: p_continue_flow => p_continue_flow );
4409: EXCEPTION
4410: WHEN OTHERS THEN
4411: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
4412: Fnd_Message.Set_Token('ROW',SQLERRM);
4413: Fnd_Msg_Pub.ADD;
4414: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
4415: END;
4416:

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

4419: COMMIT WORK;
4420: END IF;
4421: -- Debug Message
4422: IF Fnd_Msg_Pub.Check_Msg_level (Fnd_Msg_Pub.G_MSG_LVL_DEBUG_LOW) THEN
4423: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
4424: Fnd_Message.Set_Token('ROW',l_full_name||': END');
4425: Fnd_Msg_Pub.ADD;
4426: END IF;
4427: --Standard call to get message count and if count=1, get the message

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

4420: END IF;
4421: -- Debug Message
4422: IF Fnd_Msg_Pub.Check_Msg_level (Fnd_Msg_Pub.G_MSG_LVL_DEBUG_LOW) THEN
4423: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
4424: Fnd_Message.Set_Token('ROW',l_full_name||': END');
4425: Fnd_Msg_Pub.ADD;
4426: END IF;
4427: --Standard call to get message count and if count=1, get the message
4428: Fnd_Msg_Pub.Count_And_Get (

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

4615:
4616: EXCEPTION
4617: WHEN OTHERS THEN
4618: -- Commented for Bug 2485371
4619: --Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
4620: --Fnd_Message.Set_Token('ROW', SQLERRM );
4621: --Fnd_Msg_Pub.ADD;
4622: RAISE Fnd_Api.G_EXC_ERROR;
4623: Fnd_Msg_Pub.Count_And_Get (

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

4616: EXCEPTION
4617: WHEN OTHERS THEN
4618: -- Commented for Bug 2485371
4619: --Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
4620: --Fnd_Message.Set_Token('ROW', SQLERRM );
4621: --Fnd_Msg_Pub.ADD;
4622: RAISE Fnd_Api.G_EXC_ERROR;
4623: Fnd_Msg_Pub.Count_And_Get (
4624: p_encoded => Fnd_Api.G_FALSE,

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

4663: WHEN Fnd_Api.G_EXC_ERROR THEN
4664: -- raise error if not able to get the budget line
4665: -- Commented for Bug 2485371
4666: --IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
4667: -- Fnd_Message.set_name('AMS', 'AMS_BUDGET_LINE_UPDATE_ERROR');
4668: -- Fnd_Msg_Pub.ADD;
4669: --END IF;
4670: Fnd_Msg_Pub.Count_And_Get (
4671: p_encoded => Fnd_Api.G_FALSE,

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

5308: itemtype, itemkey,TO_CHAR(actid),l_error_msg);
5309: RAISE;
5310: WHEN OTHERS THEN
5311: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
5312: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
5313: Fnd_Message.Set_Token('ROW',SQLERRM);
5314: Fnd_Msg_Pub.ADD;
5315: END IF;
5316: Fnd_Msg_Pub.Count_And_Get (

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

5309: RAISE;
5310: WHEN OTHERS THEN
5311: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
5312: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
5313: Fnd_Message.Set_Token('ROW',SQLERRM);
5314: Fnd_Msg_Pub.ADD;
5315: END IF;
5316: Fnd_Msg_Pub.Count_And_Get (
5317: p_encoded => Fnd_Api.G_FALSE,

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

5474:
5475: END IF;
5476: EXCEPTION
5477: WHEN OTHERS THEN
5478: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
5479: Fnd_Message.Set_Token('ROW', SQLERRM );
5480: Fnd_Msg_Pub.ADD;
5481: RAISE Fnd_Api.G_EXC_ERROR;
5482: END;

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

5475: END IF;
5476: EXCEPTION
5477: WHEN OTHERS THEN
5478: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
5479: Fnd_Message.Set_Token('ROW', SQLERRM );
5480: Fnd_Msg_Pub.ADD;
5481: RAISE Fnd_Api.G_EXC_ERROR;
5482: END;
5483:

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

5700: END IF;
5701:
5702: EXCEPTION
5703: WHEN OTHERS THEN
5704: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
5705: Fnd_Message.Set_Token('ROW', SQLERRM );
5706: Fnd_Msg_Pub.ADD;
5707: RAISE Fnd_Api.G_EXC_ERROR;
5708: END;

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

5701:
5702: EXCEPTION
5703: WHEN OTHERS THEN
5704: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
5705: Fnd_Message.Set_Token('ROW', SQLERRM );
5706: Fnd_Msg_Pub.ADD;
5707: RAISE Fnd_Api.G_EXC_ERROR;
5708: END;
5709: -- Commented for bug 3150550

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

5931: p_approved_currency => l_approved_currency,
5932: p_comment => l_comment);
5933:
5934: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
5935: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
5936: --Fnd_Message.Set_Token('ROW', SQLERRM );
5937: Fnd_Msg_Pub.ADD;
5938:
5939: Fnd_Msg_Pub.Count_And_Get (

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

5932: p_comment => l_comment);
5933:
5934: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
5935: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
5936: --Fnd_Message.Set_Token('ROW', SQLERRM );
5937: Fnd_Msg_Pub.ADD;
5938:
5939: Fnd_Msg_Pub.Count_And_Get (
5940: p_encoded => Fnd_Api.G_FALSE,

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

5953: END IF;
5954:
5955: EXCEPTION
5956: WHEN OTHERS THEN
5957: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
5958: Fnd_Message.Set_Token('ROW', SQLERRM );
5959: Fnd_Msg_Pub.ADD;
5960: RAISE Fnd_Api.G_EXC_ERROR;
5961: END;

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

5954:
5955: EXCEPTION
5956: WHEN OTHERS THEN
5957: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
5958: Fnd_Message.Set_Token('ROW', SQLERRM );
5959: Fnd_Msg_Pub.ADD;
5960: RAISE Fnd_Api.G_EXC_ERROR;
5961: END;
5962:

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

6116:
6117: EXCEPTION
6118: WHEN OTHERS THEN
6119: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
6120: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
6121: Fnd_Message.Set_Token('ROW',SQLERRM);
6122: Fnd_Msg_Pub.ADD;
6123: END IF;
6124: Fnd_Msg_Pub.Count_And_Get (

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

6117: EXCEPTION
6118: WHEN OTHERS THEN
6119: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
6120: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
6121: Fnd_Message.Set_Token('ROW',SQLERRM);
6122: Fnd_Msg_Pub.ADD;
6123: END IF;
6124: Fnd_Msg_Pub.Count_And_Get (
6125: p_encoded => Fnd_Api.G_FALSE,

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

6264:
6265: EXCEPTION
6266: WHEN OTHERS THEN
6267: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
6268: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
6269: Fnd_Message.Set_Token('ROW',SQLERRM);
6270: Fnd_Msg_Pub.ADD;
6271: END IF;
6272: Fnd_Msg_Pub.Count_And_Get (

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

6265: EXCEPTION
6266: WHEN OTHERS THEN
6267: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
6268: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
6269: Fnd_Message.Set_Token('ROW',SQLERRM);
6270: Fnd_Msg_Pub.ADD;
6271: END IF;
6272: Fnd_Msg_Pub.Count_And_Get (
6273: p_encoded => Fnd_Api.G_FALSE,

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

6394:
6395: EXCEPTION
6396: WHEN OTHERS THEN
6397: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
6398: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
6399: Fnd_Message.Set_Token('ROW',SQLERRM);
6400: Fnd_Msg_Pub.ADD;
6401: END IF;
6402: Fnd_Msg_Pub.Count_And_Get (

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

6395: EXCEPTION
6396: WHEN OTHERS THEN
6397: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
6398: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
6399: Fnd_Message.Set_Token('ROW',SQLERRM);
6400: Fnd_Msg_Pub.ADD;
6401: END IF;
6402: Fnd_Msg_Pub.Count_And_Get (
6403: p_encoded => Fnd_Api.G_FALSE,

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

6545:
6546: EXCEPTION
6547: WHEN OTHERS THEN
6548: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
6549: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
6550: Fnd_Message.Set_Token('ROW',SQLERRM);
6551: Fnd_Msg_Pub.ADD;
6552: END IF;
6553: Fnd_Msg_Pub.Count_And_Get (

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

6546: EXCEPTION
6547: WHEN OTHERS THEN
6548: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
6549: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
6550: Fnd_Message.Set_Token('ROW',SQLERRM);
6551: Fnd_Msg_Pub.ADD;
6552: END IF;
6553: Fnd_Msg_Pub.Count_And_Get (
6554: p_encoded => Fnd_Api.G_FALSE,

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

6648:
6649: EXCEPTION
6650: WHEN OTHERS THEN
6651: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
6652: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
6653: Fnd_Message.Set_Token('ROW',SQLERRM);
6654: Fnd_Msg_Pub.ADD;
6655: END IF;
6656: Fnd_Msg_Pub.Count_And_Get (

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

6649: EXCEPTION
6650: WHEN OTHERS THEN
6651: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
6652: Fnd_Message.Set_Name('AMS','AMS_API_DEBUG_MESSAGE');
6653: Fnd_Message.Set_Token('ROW',SQLERRM);
6654: Fnd_Msg_Pub.ADD;
6655: END IF;
6656: Fnd_Msg_Pub.Count_And_Get (
6657: p_encoded => Fnd_Api.G_FALSE,