eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ASO_PA_APR_INT dependencies on FND_API

Line 11: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

7:
8:
9: PROCEDURE get_all_approvers (
10: p_api_version_number IN NUMBER,
11: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
12: p_commit IN VARCHAR2 := fnd_api.g_false,
13: p_object_id IN NUMBER,
14: p_object_type IN VARCHAR2,
15: p_application_id IN NUMBER,

Line 12: p_commit IN VARCHAR2 := fnd_api.g_false,

8:
9: PROCEDURE get_all_approvers (
10: p_api_version_number IN NUMBER,
11: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
12: p_commit IN VARCHAR2 := fnd_api.g_false,
13: p_object_id IN NUMBER,
14: p_object_type IN VARCHAR2,
15: p_application_id IN NUMBER,
16: p_object_approval_id IN NUMBER,

Line 17: p_clear_transaction_flag IN VARCHAR2 := fnd_api.g_false,

13: p_object_id IN NUMBER,
14: p_object_type IN VARCHAR2,
15: p_application_id IN NUMBER,
16: p_object_approval_id IN NUMBER,
17: p_clear_transaction_flag IN VARCHAR2 := fnd_api.g_false,
18: p_data_flag IN VARCHAR2 :='Y',
19: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
20: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
21: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 158: IF NOT fnd_api.compatible_api_call (

154: SAVEPOINT get_all_approvers_int;
155:
156: -- Standard call to check for call compatibility.
157:
158: IF NOT fnd_api.compatible_api_call (
159: l_api_version,
160: p_api_version_number,
161: l_api_name,
162: g_pkg_name

Line 172: RAISE fnd_api.g_exc_unexpected_error;

168: 1,
169: 'N'
170: );
171: END IF;
172: RAISE fnd_api.g_exc_unexpected_error;
173: END IF;
174:
175: -- Initialize message list if p_init_msg_list is set to TRUE
176:

Line 177: IF fnd_api.to_boolean (

173: END IF;
174:
175: -- Initialize message list if p_init_msg_list is set to TRUE
176:
177: IF fnd_api.to_boolean (
178: p_init_msg_list
179: )
180: THEN
181: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 193: x_return_status := fnd_api.g_ret_sts_success;

189: END IF;
190:
191: -- Initialize API return status to success
192:
193: x_return_status := fnd_api.g_ret_sts_success;
194:
195: --pp_debug('p_data_flag'||p_data_flag);
196: --pp_debug('p_object_approval_id'||p_object_approval_id);
197:

Line 218: IF fnd_api.to_boolean (

214: end if;
215:
216: -- Clear all transactions if the flag is set to true
217:
218: IF fnd_api.to_boolean (
219: p_clear_transaction_flag
220: )
221: THEN
222: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 631: IF fnd_api.to_boolean (

627: end loop;
628: */
629: -- commit the work
630:
631: IF fnd_api.to_boolean (
632: p_commit
633: )
634: THEN
635: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 653: WHEN fnd_api.g_exc_error

649: 'N'
650: );
651: END IF;
652: EXCEPTION
653: WHEN fnd_api.g_exc_error
654: THEN
655: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
656: aso_debug_pub.ADD (
657: 'Exception FND_API.G_EXC_ERROR in get_all_approvers ',

Line 657: 'Exception FND_API.G_EXC_ERROR in get_all_approvers ',

653: WHEN fnd_api.g_exc_error
654: THEN
655: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
656: aso_debug_pub.ADD (
657: 'Exception FND_API.G_EXC_ERROR in get_all_approvers ',
658: 1,
659: 'N'
660: );
661: END IF;

Line 673: WHEN fnd_api.g_exc_unexpected_error

669: x_msg_count => x_msg_count,
670: x_msg_data => x_msg_data,
671: x_return_status => x_return_status
672: );
673: WHEN fnd_api.g_exc_unexpected_error
674: THEN
675: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
676: aso_debug_pub.ADD (
677: 'Exception FND_API.G_EXC_UNEXPECTED_ERROR in get_all_approvers ',

Line 677: 'Exception FND_API.G_EXC_UNEXPECTED_ERROR in get_all_approvers ',

673: WHEN fnd_api.g_exc_unexpected_error
674: THEN
675: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
676: aso_debug_pub.ADD (
677: 'Exception FND_API.G_EXC_UNEXPECTED_ERROR in get_all_approvers ',
678: 1,
679: 'N'
680: );
681: END IF;

Line 718: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

714:
715:
716: PROCEDURE start_papproval_process (
717: p_api_version_number IN NUMBER,
718: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
719: p_commit IN VARCHAR2 := fnd_api.g_false,
720: p_object_id IN NUMBER,
721: p_object_type IN VARCHAR2,
722: p_application_id IN NUMBER,

Line 719: p_commit IN VARCHAR2 := fnd_api.g_false,

715:
716: PROCEDURE start_papproval_process (
717: p_api_version_number IN NUMBER,
718: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
719: p_commit IN VARCHAR2 := fnd_api.g_false,
720: p_object_id IN NUMBER,
721: p_object_type IN VARCHAR2,
722: p_application_id IN NUMBER,
723: p_requester_comments IN VARCHAR2,

Line 813: IF NOT fnd_api.compatible_api_call (

809: END IF;
810: SAVEPOINT start_papproval_process_int;
811:
812: -- Standard call to check for call compatibility.
813: IF NOT fnd_api.compatible_api_call (
814: l_api_version,
815: p_api_version_number,
816: l_api_name,
817: g_pkg_name

Line 827: RAISE fnd_api.g_exc_unexpected_error;

823: 1,
824: 'N'
825: );
826: END IF;
827: RAISE fnd_api.g_exc_unexpected_error;
828: END IF;
829:
830: -- Initialize message list if p_init_msg_list is set to TRUE
831:

Line 832: IF fnd_api.to_boolean (

828: END IF;
829:
830: -- Initialize message list if p_init_msg_list is set to TRUE
831:
832: IF fnd_api.to_boolean (
833: p_init_msg_list
834: )
835: THEN
836: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 847: x_return_status := fnd_api.g_ret_sts_success;

843: fnd_msg_pub.initialize;
844: END IF;
845:
846: -- Initialize API return status to success
847: x_return_status := fnd_api.g_ret_sts_success;
848:
849:
850: OPEN C_get_duplicate_approval;
851: FETCH C_get_duplicate_approval INTO l_dup_approval ;

Line 1111: IF fnd_api.to_boolean (

1107: END IF;
1108:
1109: -- commit the work
1110:
1111: IF fnd_api.to_boolean (
1112: p_commit
1113: )
1114: THEN
1115: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 1133: WHEN fnd_api.g_exc_error

1129: 'N'
1130: );
1131: END IF;
1132: EXCEPTION
1133: WHEN fnd_api.g_exc_error
1134: THEN
1135: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1136: aso_debug_pub.ADD (
1137: 'Exception FND_API.G_EXC_ERROR in start_papproval_process',

Line 1137: 'Exception FND_API.G_EXC_ERROR in start_papproval_process',

1133: WHEN fnd_api.g_exc_error
1134: THEN
1135: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1136: aso_debug_pub.ADD (
1137: 'Exception FND_API.G_EXC_ERROR in start_papproval_process',
1138: 1,
1139: 'N'
1140: );
1141: END IF;

Line 1153: WHEN fnd_api.g_exc_unexpected_error

1149: x_msg_count => x_msg_count,
1150: x_msg_data => x_msg_data,
1151: x_return_status => x_return_status
1152: );
1153: WHEN fnd_api.g_exc_unexpected_error
1154: THEN
1155: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1156: aso_debug_pub.ADD (
1157: 'Exception FND_API.G_EXC_UNEXPECTED_ERROR in start_papproval_process',

Line 1157: 'Exception FND_API.G_EXC_UNEXPECTED_ERROR in start_papproval_process',

1153: WHEN fnd_api.g_exc_unexpected_error
1154: THEN
1155: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1156: aso_debug_pub.ADD (
1157: 'Exception FND_API.G_EXC_UNEXPECTED_ERROR in start_papproval_process',
1158: 1,
1159: 'N'
1160: );
1161: END IF;

Line 1277: IF NOT fnd_api.compatible_api_call (

1273: END IF;
1274: SAVEPOINT cancel_approval_process_int;
1275:
1276: -- Standard call to check for call compatibility.
1277: IF NOT fnd_api.compatible_api_call (
1278: l_api_version,
1279: p_api_version_number,
1280: l_api_name,
1281: g_pkg_name

Line 1291: RAISE fnd_api.g_exc_unexpected_error;

1287: 1,
1288: 'N'
1289: );
1290: END IF;
1291: RAISE fnd_api.g_exc_unexpected_error;
1292: END IF;
1293:
1294: -- Initialize message list if p_init_msg_list is set to TRUE
1295:

Line 1296: IF fnd_api.to_boolean (

1292: END IF;
1293:
1294: -- Initialize message list if p_init_msg_list is set to TRUE
1295:
1296: IF fnd_api.to_boolean (
1297: p_init_msg_list
1298: )
1299: THEN
1300: fnd_msg_pub.initialize;

Line 1304: x_return_status := fnd_api.g_ret_sts_success;

1300: fnd_msg_pub.initialize;
1301: END IF;
1302:
1303: -- Initialize API return status to success
1304: x_return_status := fnd_api.g_ret_sts_success;
1305:
1306: -- Check to see if required parameters are passed
1307: IF ( ((P_Object_approval_id IS NULL) OR (P_Object_approval_id = FND_API.G_MISS_NUM)) AND
1308: ((p_object_id IS NULL) OR (p_object_id = FND_API.G_MISS_NUM)) AND

Line 1307: IF ( ((P_Object_approval_id IS NULL) OR (P_Object_approval_id = FND_API.G_MISS_NUM)) AND

1303: -- Initialize API return status to success
1304: x_return_status := fnd_api.g_ret_sts_success;
1305:
1306: -- Check to see if required parameters are passed
1307: IF ( ((P_Object_approval_id IS NULL) OR (P_Object_approval_id = FND_API.G_MISS_NUM)) AND
1308: ((p_object_id IS NULL) OR (p_object_id = FND_API.G_MISS_NUM)) AND
1309: ((p_object_type IS NULL) OR (p_object_type = FND_API.G_MISS_CHAR)) ) THEN
1310:
1311: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_INVALID_ID' );

Line 1308: ((p_object_id IS NULL) OR (p_object_id = FND_API.G_MISS_NUM)) AND

1304: x_return_status := fnd_api.g_ret_sts_success;
1305:
1306: -- Check to see if required parameters are passed
1307: IF ( ((P_Object_approval_id IS NULL) OR (P_Object_approval_id = FND_API.G_MISS_NUM)) AND
1308: ((p_object_id IS NULL) OR (p_object_id = FND_API.G_MISS_NUM)) AND
1309: ((p_object_type IS NULL) OR (p_object_type = FND_API.G_MISS_CHAR)) ) THEN
1310:
1311: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_INVALID_ID' );
1312: FND_MESSAGE.Set_Token ('COLUMN' , 'P_Object_approval_id', FALSE );

Line 1309: ((p_object_type IS NULL) OR (p_object_type = FND_API.G_MISS_CHAR)) ) THEN

1305:
1306: -- Check to see if required parameters are passed
1307: IF ( ((P_Object_approval_id IS NULL) OR (P_Object_approval_id = FND_API.G_MISS_NUM)) AND
1308: ((p_object_id IS NULL) OR (p_object_id = FND_API.G_MISS_NUM)) AND
1309: ((p_object_type IS NULL) OR (p_object_type = FND_API.G_MISS_CHAR)) ) THEN
1310:
1311: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_INVALID_ID' );
1312: FND_MESSAGE.Set_Token ('COLUMN' , 'P_Object_approval_id', FALSE );
1313: FND_MESSAGE.Set_Token ( 'VALUE' , TO_CHAR ( P_Object_approval_id ) , FALSE );

Line 1315: RAISE FND_API.G_EXC_ERROR;

1311: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_INVALID_ID' );
1312: FND_MESSAGE.Set_Token ('COLUMN' , 'P_Object_approval_id', FALSE );
1313: FND_MESSAGE.Set_Token ( 'VALUE' , TO_CHAR ( P_Object_approval_id ) , FALSE );
1314: FND_MSG_PUB.ADD;
1315: RAISE FND_API.G_EXC_ERROR;
1316: END IF;
1317:
1318: IF (p_object_approval_id IS NULL)
1319: OR (p_object_approval_id = fnd_api.g_miss_num)

Line 1319: OR (p_object_approval_id = fnd_api.g_miss_num)

1315: RAISE FND_API.G_EXC_ERROR;
1316: END IF;
1317:
1318: IF (p_object_approval_id IS NULL)
1319: OR (p_object_approval_id = fnd_api.g_miss_num)
1320: THEN
1321: FOR i IN get_approval_id (
1322: p_object_id,
1323: p_object_type

Line 1369: IF fnd_api.to_boolean (

1365: END IF;
1366:
1367: -- Commit the work
1368:
1369: IF fnd_api.to_boolean (
1370: p_commit
1371: )
1372: THEN
1373: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 1399: WHEN fnd_api.g_exc_error

1395: 'N'
1396: );
1397: END IF;
1398: EXCEPTION
1399: WHEN fnd_api.g_exc_error
1400: THEN
1401: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1402: aso_debug_pub.ADD (
1403: 'Exception FND_API.G_EXC_ERROR in CancelApproval',

Line 1403: 'Exception FND_API.G_EXC_ERROR in CancelApproval',

1399: WHEN fnd_api.g_exc_error
1400: THEN
1401: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1402: aso_debug_pub.ADD (
1403: 'Exception FND_API.G_EXC_ERROR in CancelApproval',
1404: 1,
1405: 'N'
1406: );
1407: END IF;

Line 1419: WHEN fnd_api.g_exc_unexpected_error

1415: x_msg_count => x_msg_count,
1416: x_msg_data => x_msg_data,
1417: x_return_status => x_return_status
1418: );
1419: WHEN fnd_api.g_exc_unexpected_error
1420: THEN
1421: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1422: aso_debug_pub.ADD (
1423: 'Exception FND_API.G_EXC_UNEXPECTED_ERROR in CancelApproval',

Line 1423: 'Exception FND_API.G_EXC_UNEXPECTED_ERROR in CancelApproval',

1419: WHEN fnd_api.g_exc_unexpected_error
1420: THEN
1421: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1422: aso_debug_pub.ADD (
1423: 'Exception FND_API.G_EXC_UNEXPECTED_ERROR in CancelApproval',
1424: 1,
1425: 'N'
1426: );
1427: END IF;

Line 1463: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

1459: END cancel_approval_process;
1460:
1461: PROCEDURE start_pa_approval_workflow (
1462: p_api_version_number IN NUMBER,
1463: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
1464: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
1465: P_Object_approval_id IN NUMBER,
1466: P_itemtype IN VARCHAR2,
1467: P_sender_name IN VARCHAR2,

Line 1464: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

1460:
1461: PROCEDURE start_pa_approval_workflow (
1462: p_api_version_number IN NUMBER,
1463: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
1464: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
1465: P_Object_approval_id IN NUMBER,
1466: P_itemtype IN VARCHAR2,
1467: P_sender_name IN VARCHAR2,
1468: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 1510: IF NOT fnd_api.compatible_api_call (

1506: );
1507: END IF;
1508:
1509: -- Standard call to check for call compatibility.
1510: IF NOT fnd_api.compatible_api_call (
1511: l_api_version,
1512: p_api_version_number,
1513: l_api_name,
1514: g_pkg_name

Line 1517: RAISE fnd_api.g_exc_unexpected_error;

1513: l_api_name,
1514: g_pkg_name
1515: )
1516: THEN
1517: RAISE fnd_api.g_exc_unexpected_error;
1518: END IF;
1519:
1520: -- Initialize message list if p_init_msg_list is set to TRUE
1521: IF fnd_api.to_boolean (

Line 1521: IF fnd_api.to_boolean (

1517: RAISE fnd_api.g_exc_unexpected_error;
1518: END IF;
1519:
1520: -- Initialize message list if p_init_msg_list is set to TRUE
1521: IF fnd_api.to_boolean (
1522: p_init_msg_list
1523: )
1524: THEN
1525: fnd_msg_pub.initialize;

Line 1529: x_return_status := fnd_api.g_ret_sts_success;

1525: fnd_msg_pub.initialize;
1526: END IF;
1527:
1528: -- Initialize API return status to success
1529: x_return_status := fnd_api.g_ret_sts_success;
1530:
1531: -- Check to see if required parameters are passed
1532: IF ((P_Object_approval_id IS NULL) OR (P_Object_approval_id = FND_API.G_MISS_NUM)) THEN
1533: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_INVALID_ID' );

Line 1532: IF ((P_Object_approval_id IS NULL) OR (P_Object_approval_id = FND_API.G_MISS_NUM)) THEN

1528: -- Initialize API return status to success
1529: x_return_status := fnd_api.g_ret_sts_success;
1530:
1531: -- Check to see if required parameters are passed
1532: IF ((P_Object_approval_id IS NULL) OR (P_Object_approval_id = FND_API.G_MISS_NUM)) THEN
1533: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_INVALID_ID' );
1534: FND_MESSAGE.Set_Token ('COLUMN' , 'P_Object_approval_id', FALSE );
1535: FND_MESSAGE.Set_Token ( 'VALUE' , TO_CHAR ( P_Object_approval_id ) , FALSE );
1536: FND_MSG_PUB.ADD;

Line 1537: RAISE FND_API.G_EXC_ERROR;

1533: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_INVALID_ID' );
1534: FND_MESSAGE.Set_Token ('COLUMN' , 'P_Object_approval_id', FALSE );
1535: FND_MESSAGE.Set_Token ( 'VALUE' , TO_CHAR ( P_Object_approval_id ) , FALSE );
1536: FND_MSG_PUB.ADD;
1537: RAISE FND_API.G_EXC_ERROR;
1538: ELSIF ((P_itemtype IS NULL) OR (P_itemtype = FND_API.G_MISS_CHAR)) THEN
1539: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_INVALID_ID' );
1540: FND_MESSAGE.Set_Token ('COLUMN' , 'P_Object_approval_id', FALSE );
1541: FND_MESSAGE.Set_Token ( 'VALUE' , TO_CHAR ( P_Object_approval_id ) , FALSE );

Line 1538: ELSIF ((P_itemtype IS NULL) OR (P_itemtype = FND_API.G_MISS_CHAR)) THEN

1534: FND_MESSAGE.Set_Token ('COLUMN' , 'P_Object_approval_id', FALSE );
1535: FND_MESSAGE.Set_Token ( 'VALUE' , TO_CHAR ( P_Object_approval_id ) , FALSE );
1536: FND_MSG_PUB.ADD;
1537: RAISE FND_API.G_EXC_ERROR;
1538: ELSIF ((P_itemtype IS NULL) OR (P_itemtype = FND_API.G_MISS_CHAR)) THEN
1539: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_INVALID_ID' );
1540: FND_MESSAGE.Set_Token ('COLUMN' , 'P_Object_approval_id', FALSE );
1541: FND_MESSAGE.Set_Token ( 'VALUE' , TO_CHAR ( P_Object_approval_id ) , FALSE );
1542: FND_MSG_PUB.ADD;

Line 1543: RAISE FND_API.G_EXC_ERROR;

1539: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_INVALID_ID' );
1540: FND_MESSAGE.Set_Token ('COLUMN' , 'P_Object_approval_id', FALSE );
1541: FND_MESSAGE.Set_Token ( 'VALUE' , TO_CHAR ( P_Object_approval_id ) , FALSE );
1542: FND_MSG_PUB.ADD;
1543: RAISE FND_API.G_EXC_ERROR;
1544: END IF;
1545:
1546: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1547: aso_debug_pub.ADD (

Line 1571: IF fnd_api.to_boolean (

1567:
1568:
1569: -- Commit the work
1570:
1571: IF fnd_api.to_boolean (
1572: p_commit
1573: )
1574: THEN
1575: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 1605: WHEN fnd_api.g_exc_error

1601: END IF;
1602:
1603:
1604: EXCEPTION
1605: WHEN fnd_api.g_exc_error
1606: THEN
1607: aso_utility_pvt.handle_exceptions (
1608: p_api_name => l_api_name,
1609: p_pkg_name => g_pkg_name,

Line 1618: WHEN fnd_api.g_exc_unexpected_error

1614: x_msg_count => x_msg_count,
1615: x_msg_data => x_msg_data,
1616: x_return_status => x_return_status
1617: );
1618: WHEN fnd_api.g_exc_unexpected_error
1619: THEN
1620: aso_utility_pvt.handle_exceptions (
1621: p_api_name => l_api_name,
1622: p_pkg_name => g_pkg_name,

Line 1694: x_return_status := fnd_api.g_ret_sts_success;

1690: aso_debug_pub.add('upd_status_self_appr: BEGIN ', 1, 'Y');
1691: END IF;
1692:
1693: -- Initialize API return status to success
1694: x_return_status := fnd_api.g_ret_sts_success;
1695:
1696: SAVEPOINT upd_status_self_appr_int;
1697:
1698: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 1712: raise FND_API.G_EXC_ERROR;

1708: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_UPDATE_TARGET');
1709: FND_MESSAGE.Set_Token ('INFO', 'quote', FALSE);
1710: FND_MSG_PUB.Add;
1711: END IF;
1712: raise FND_API.G_EXC_ERROR;
1713: END IF;
1714: Close c_get_qte_info;
1715:
1716: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 1721: If (l_last_update_date is NULL or l_last_update_date = FND_API.G_MISS_Date ) Then

1717: aso_debug_pub.add('upd_status_self_appr: l_LAST_UPDATE_DATE: '|| l_LAST_UPDATE_DATE, 1, 'Y');
1718: aso_debug_pub.add('upd_status_self_appr: l_object_version_number: '|| l_object_version_number,1,'Y');
1719: END IF;
1720:
1721: If (l_last_update_date is NULL or l_last_update_date = FND_API.G_MISS_Date ) Then
1722: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1723: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');
1724: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
1725: FND_MSG_PUB.ADD;

Line 1727: raise FND_API.G_EXC_ERROR;

1723: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');
1724: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
1725: FND_MSG_PUB.ADD;
1726: END IF;
1727: raise FND_API.G_EXC_ERROR;
1728: End if;
1729:
1730: -- Check Whether record has been changed by someone else
1731: If ( (l_last_update_date <> p_last_update_date ) OR (l_object_version_number <> p_obj_ver_num ) ) Then

Line 1737: raise FND_API.G_EXC_ERROR;

1733: FND_MESSAGE.Set_Name('ASO', 'ASO_API_RECORD_CHANGED');
1734: FND_MESSAGE.Set_Token('INFO', 'quote', FALSE);
1735: FND_MSG_PUB.ADD;
1736: END IF;
1737: raise FND_API.G_EXC_ERROR;
1738: End if;
1739:
1740: OPEN C_Get_Status;
1741: FETCH C_Get_Status into l_status_id;

Line 1825: WHEN fnd_api.g_exc_error

1821: aso_debug_pub.add('upd_status_self_appr: END ', 1, 'Y');
1822: END IF;
1823:
1824: EXCEPTION
1825: WHEN fnd_api.g_exc_error
1826: THEN
1827: aso_utility_pvt.handle_exceptions (
1828: p_api_name => l_api_name,
1829: p_pkg_name => g_pkg_name,

Line 1838: WHEN fnd_api.g_exc_unexpected_error

1834: x_msg_count => x_msg_count,
1835: x_msg_data => x_msg_data,
1836: x_return_status => x_return_status
1837: );
1838: WHEN fnd_api.g_exc_unexpected_error
1839: THEN
1840: aso_utility_pvt.handle_exceptions (
1841: p_api_name => l_api_name,
1842: p_pkg_name => g_pkg_name,

Line 1926: x_return_status := fnd_api.g_ret_sts_success;

1922: END IF;
1923:
1924: --pp_debug('insert_approvers_gtt: BEGIN');
1925: -- Initialize API return status to success
1926: x_return_status := fnd_api.g_ret_sts_success;
1927:
1928: SAVEPOINT insert_approvers_gtt;
1929:
1930: select approval_status

Line 2109: WHEN fnd_api.g_exc_error

2105: */
2106:
2107: exception
2108:
2109: WHEN fnd_api.g_exc_error
2110: THEN
2111: aso_utility_pvt.handle_exceptions (
2112: p_api_name => l_api_name,
2113: p_pkg_name => g_pkg_name,

Line 2122: WHEN fnd_api.g_exc_unexpected_error

2118: x_msg_count => x_msg_count,
2119: x_msg_data => x_msg_data,
2120: x_return_status => x_return_status
2121: );
2122: WHEN fnd_api.g_exc_unexpected_error
2123: THEN
2124: aso_utility_pvt.handle_exceptions (
2125: p_api_name => l_api_name,
2126: p_pkg_name => g_pkg_name,