DBA Data[Home] [Help]

APPS.AMW_PROC_ORG_HIERARCHY_PVT dependencies on STANDARD

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

276:
277: --Debug Message
278: AMW_UTILITY_PVT.debug_message('Private API: ' || L_API_NAME || 'end');
279:
280: -- Standard call to get message count and if count is 1, get message info.
281: FND_MSG_PUB.Count_And_Get(
282: p_count => x_msg_count,
283: p_data => x_msg_data
284: );

Line 290: -- Standard call to get message count and if count=1, get the message

286: exception
287: WHEN FND_API.G_EXC_ERROR THEN
288: ROLLBACK TO process_process_hierarchy_pub;
289: x_return_status := FND_API.G_RET_STS_ERROR;
290: -- Standard call to get message count and if count=1, get the message
291: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
292:
293: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
294: ROLLBACK TO process_process_hierarchy_pub;

Line 296: -- Standard call to get message count and if count=1, get the message

292:
293: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
294: ROLLBACK TO process_process_hierarchy_pub;
295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
296: -- Standard call to get message count and if count=1, get the message
297: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
298:
299: WHEN OTHERS THEN
300: ROLLBACK TO process_process_hierarchy_pub;

Line 306: -- Standard call to get message count and if count=1, get the message

302: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
303: THEN
304: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
305: END IF;
306: -- Standard call to get message count and if count=1, get the message
307: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
308: end process_process_hierarchy;
309:
310: -- ==============================================================================

Line 371: select significant_process_flag,standard_process_flag,approval_status,

367: x_process_organization_id number := 0;
368: l_apo_type apo_type := p_apo_type;
369:
370: cursor c1 is
371: select significant_process_flag,standard_process_flag,approval_status,
372: certification_status,process_category,process_owner_id,process_id,created_from,
373: request_id,program_application_id,program_id,program_update_date,
374: attribute_category,attribute1,attribute2,attribute3,attribute4,
375: attribute5,attribute6,attribute7,attribute8,attribute9,attribute10,

Line 448: l_apo_type.STANDARD_PROCESS_FLAG := l_amwp_rowtype.STANDARD_PROCESS_FLAG;

444: l_apo_type.creation_date := sysdate;
445: l_apo_type.created_by := G_USER_ID;
446: l_apo_type.LAST_UPDATE_LOGIN := G_LOGIN_ID;
447: l_apo_type.PROCESS_ID := p_PROCESS_ID;
448: l_apo_type.STANDARD_PROCESS_FLAG := l_amwp_rowtype.STANDARD_PROCESS_FLAG;
449: l_apo_type.RISK_CATEGORY := null;
450: l_apo_type.APPROVAL_STATUS := l_amwp_rowtype.APPROVAL_STATUS;
451: l_apo_type.CERTIFICATION_STATUS := l_amwp_rowtype.CERTIFICATION_STATUS;
452: l_apo_type.LAST_AUDIT_STATUS := null;

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

598: END IF;
599:
600: AMW_UTILITY_PVT.debug_message('Private API: ' || L_API_NAME || 'end');
601:
602: -- Standard call to get message count and if count is 1, get message info.
603: FND_MSG_PUB.Count_And_Get(
604: p_count => x_msg_count,
605: p_data => x_msg_data
606: );

Line 614: -- Standard call to get message count and if count=1, get the message

610: exception
611: WHEN FND_API.G_EXC_ERROR THEN
612: ROLLBACK TO associate_process_org_pvt;
613: x_return_status := FND_API.G_RET_STS_ERROR;
614: -- Standard call to get message count and if count=1, get the message
615: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
616:
617: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
618: ROLLBACK TO associate_process_org_pvt;

Line 620: -- Standard call to get message count and if count=1, get the message

616:
617: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
618: ROLLBACK TO associate_process_org_pvt;
619: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
620: -- Standard call to get message count and if count=1, get the message
621: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
622:
623: WHEN OTHERS THEN
624: ROLLBACK TO associate_process_org_pvt;

Line 630: -- Standard call to get message count and if count=1, get the message

626: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
627: THEN
628: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
629: END IF;
630: -- Standard call to get message count and if count=1, get the message
631: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
632:
633: end associate_process_org;
634:

Line 733: standard_process_flag,

729: creation_date,
730: created_by,
731: LAST_UPDATE_LOGIN,
732: process_id,
733: standard_process_flag,
734: risk_category,
735: approval_status,
736: certification_status,
737: last_audit_status,

Line 781: decode(p_apo_type.standard_process_flag,null,'Y',p_apo_type.standard_process_flag),

777: sysdate,
778: G_USER_ID,
779: G_LOGIN_ID,
780: p_apo_type.process_id,
781: decode(p_apo_type.standard_process_flag,null,'Y',p_apo_type.standard_process_flag),
782: decode(p_apo_type.risk_category,null,'High',p_apo_type.risk_category),
783: p_apo_type.approval_status,
784: p_apo_type.certification_status,
785: p_apo_type.last_audit_status,

Line 921: -- Standard check for p_commit

917: where process_id=p_apo_type.process_id; */
918: end if;
919:
920: ---DBMS_OUTPUT.PUT_LINE(FND_API.to_Boolean(p_commit));
921: -- Standard check for p_commit
922: IF FND_API.to_Boolean(p_commit)
923: THEN
924: COMMIT WORK;
925: END IF;

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

986:
987: -- Debug Message
988: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' end');
989:
990: -- Standard call to get message count and if count is 1, get message info.
991: FND_MSG_PUB.Count_And_Get(
992: p_count => x_msg_count,
993: p_data => x_msg_data
994: );

Line 1000: -- Standard call to get message count and if count=1, get the message

996: exception
997: WHEN FND_API.G_EXC_ERROR THEN
998: ROLLBACK TO insert_in_amwpo_pvt;
999: x_return_status := FND_API.G_RET_STS_ERROR;
1000: -- Standard call to get message count and if count=1, get the message
1001: FND_MSG_PUB.Count_And_Get (
1002: p_encoded => FND_API.G_FALSE,
1003: p_count => x_msg_count,
1004: p_data => x_msg_data

Line 1010: -- Standard call to get message count and if count=1, get the message

1006:
1007: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1008: ROLLBACK TO insert_in_amwpo_pvt;
1009: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1010: -- Standard call to get message count and if count=1, get the message
1011: FND_MSG_PUB.Count_And_Get (
1012: p_encoded => FND_API.G_FALSE,
1013: p_count => x_msg_count,
1014: p_data => x_msg_data

Line 1024: -- Standard call to get message count and if count=1, get the message

1020: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1021: THEN
1022: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1023: END IF;
1024: -- Standard call to get message count and if count=1, get the message
1025: FND_MSG_PUB.Count_And_Get (
1026: p_encoded => FND_API.G_FALSE,
1027: p_count => x_msg_count,
1028: p_data => x_msg_data

Line 1377: -- Standard check for p_commit

1373: IF X_ROWID is null THEN
1374: RAISE FND_API.G_EXC_ERROR;
1375: END IF;
1376:
1377: -- Standard check for p_commit
1378: IF FND_API.to_Boolean( p_commit )
1379: THEN
1380: COMMIT WORK;
1381: END IF;

Line 1398: -- Standard check for p_commit

1394: and pk1=p_process_organization_id;
1395:
1396: ---------------------dbms_output.put_line('In amw_risk_associations: deleting');
1397:
1398: -- Standard check for p_commit
1399: IF FND_API.to_Boolean( p_commit )
1400: THEN
1401: COMMIT WORK;
1402: END IF;

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

1414: -- Debug Message
1415: ---AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1416: AMW_UTILITY_PVT.debug_message(l_api_name || '_end');
1417:
1418: -- Standard call to get message count and if count is 1, get message info.
1419: FND_MSG_PUB.Count_And_Get(
1420: p_count => x_msg_count,
1421: p_data => x_msg_data
1422: );

Line 1428: -- Standard call to get message count and if count=1, get the message

1424: exception
1425: WHEN FND_API.G_EXC_ERROR THEN
1426: ROLLBACK TO assoc_acct_pvt;
1427: x_return_status := FND_API.G_RET_STS_ERROR;
1428: -- Standard call to get message count and if count=1, get the message
1429: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1430:
1431: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1432: ROLLBACK TO assoc_acct_pvt;

Line 1434: -- Standard call to get message count and if count=1, get the message

1430:
1431: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1432: ROLLBACK TO assoc_acct_pvt;
1433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1434: -- Standard call to get message count and if count=1, get the message
1435: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1436:
1437: WHEN OTHERS THEN
1438: ROLLBACK TO assoc_acct_pvt;

Line 1444: -- Standard call to get message count and if count=1, get the message

1440: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1441: THEN
1442: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
1443: END IF;
1444: -- Standard call to get message count and if count=1, get the message
1445: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1446: end process_amw_acct_assoc;
1447:
1448: -- ==============================================================================

Line 1586: -- Standard check for p_commit

1582: ---added by npanandi on 01/22/2004 for 3362371 bug fix
1583: ,l_ara_row.material,l_ara_row.material_value
1584: ---finished addition on 01/22/2004
1585: );
1586: -- Standard check for p_commit
1587: IF FND_API.to_Boolean( p_commit )
1588: THEN
1589: COMMIT WORK;
1590: END IF;

Line 1624: -- Standard check for p_commit

1620: and pk1=p_process_organization_id;
1621:
1622: ---------------------dbms_output.put_line('In amw_risk_associations: deleting');
1623:
1624: -- Standard check for p_commit
1625: IF FND_API.to_Boolean( p_commit )
1626: THEN
1627: COMMIT WORK;
1628: END IF;

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

1650: -------------------dbms_output.put_line('Process_AMW_Risk_Assoc x_return_status: '||x_return_status);
1651: -- Debug Message
1652: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1653:
1654: -- Standard call to get message count and if count is 1, get message info.
1655: FND_MSG_PUB.Count_And_Get(
1656: p_count => x_msg_count,
1657: p_data => x_msg_data
1658: );

Line 1664: -- Standard call to get message count and if count=1, get the message

1660: exception
1661: WHEN FND_API.G_EXC_ERROR THEN
1662: ROLLBACK TO assoc_risk_pvt;
1663: x_return_status := FND_API.G_RET_STS_ERROR;
1664: -- Standard call to get message count and if count=1, get the message
1665: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1666:
1667: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1668: ROLLBACK TO assoc_risk_pvt;

Line 1670: -- Standard call to get message count and if count=1, get the message

1666:
1667: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1668: ROLLBACK TO assoc_risk_pvt;
1669: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1670: -- Standard call to get message count and if count=1, get the message
1671: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1672:
1673: WHEN OTHERS THEN
1674: ROLLBACK TO assoc_risk_pvt;

Line 1680: -- Standard call to get message count and if count=1, get the message

1676: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1677: THEN
1678: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
1679: END IF;
1680: -- Standard call to get message count and if count=1, get the message
1681: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1682: end process_amw_risk_assoc;
1683:
1684: -- ==============================================================================

Line 1803: -- Standard check for p_commit

1799: l_aca_row.attribute9,l_aca_row.attribute10,l_aca_row.attribute11,l_aca_row.attribute12,
1800: l_aca_row.attribute13,l_aca_row.attribute14,l_aca_row.attribute15,
1801: l_aca_row.security_group_id,1,
1802: l_aca_row.effective_date_from,l_aca_row.effective_date_to);
1803: -- Standard check for p_commit
1804: IF FND_API.to_Boolean( p_commit )
1805: THEN
1806: COMMIT WORK;
1807: END IF;

Line 1858: -- Standard check for p_commit

1854:
1855: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1856: RAISE FND_API.G_EXC_ERROR;
1857: END IF;
1858: -- Standard check for p_commit
1859: IF FND_API.to_Boolean( p_commit )
1860: THEN
1861: COMMIT WORK;
1862: END IF;

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

1867: -------------------dbms_output.put_line('Process_AMW_Control_Assoc x_return_status: '||x_return_status);
1868: -- Debug Message
1869: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1870:
1871: -- Standard call to get message count and if count is 1, get message info.
1872: FND_MSG_PUB.Count_And_Get(
1873: p_count => x_msg_count,
1874: p_data => x_msg_data
1875: );

Line 1881: -- Standard call to get message count and if count=1, get the message

1877: exception
1878: WHEN FND_API.G_EXC_ERROR THEN
1879: ROLLBACK TO assoc_control_pvt;
1880: x_return_status := FND_API.G_RET_STS_ERROR;
1881: -- Standard call to get message count and if count=1, get the message
1882: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1883:
1884: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1885: ROLLBACK TO assoc_control_pvt;

Line 1887: -- Standard call to get message count and if count=1, get the message

1883:
1884: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1885: ROLLBACK TO assoc_control_pvt;
1886: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1887: -- Standard call to get message count and if count=1, get the message
1888: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1889:
1890: WHEN OTHERS THEN
1891: ROLLBACK TO assoc_control_pvt;

Line 1897: -- Standard call to get message count and if count=1, get the message

1893: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1894: THEN
1895: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
1896: END IF;
1897: -- Standard call to get message count and if count=1, get the message
1898: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
1899: end process_amw_control_assoc;
1900:
1901: -- ==============================================================================

Line 2058: -- Standard check for p_commit

2054: l_aaa_row.attribute11,l_aaa_row.attribute12,l_aaa_row.attribute13,l_aaa_row.attribute14,
2055: l_aaa_row.attribute15,l_aaa_row.security_group_id,1,
2056: l_aaa_row.design_effectiveness,l_aaa_row.op_effectiveness);
2057:
2058: -- Standard check for p_commit
2059: IF FND_API.to_Boolean( p_commit )
2060: THEN
2061: COMMIT WORK;
2062: END IF;

Line 2078: -- Standard check for p_commit

2074: -- commented by mpande
2075: -- and object_type='CTRL_ORG' ;
2076: -- and pk1=p_control_association_id;
2077:
2078: -- Standard check for p_commit
2079: IF FND_API.to_Boolean( p_commit )
2080: THEN
2081: COMMIT WORK;
2082: END IF;

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

2088: -----------------------dbms_output.put_line('Process_AMW_AP_Assoc x_return_status: '||x_return_status);
2089: -- Debug Message
2090: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
2091:
2092: -- Standard call to get message count and if count is 1, get message info.
2093: FND_MSG_PUB.Count_And_Get(
2094: p_count => x_msg_count,
2095: p_data => x_msg_data
2096: );

Line 2102: -- Standard call to get message count and if count=1, get the message

2098: exception
2099: WHEN FND_API.G_EXC_ERROR THEN
2100: ROLLBACK TO assoc_ap_pvt;
2101: x_return_status := FND_API.G_RET_STS_ERROR;
2102: -- Standard call to get message count and if count=1, get the message
2103: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
2104:
2105: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2106: ROLLBACK TO assoc_ap_pvt;

Line 2108: -- Standard call to get message count and if count=1, get the message

2104:
2105: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2106: ROLLBACK TO assoc_ap_pvt;
2107: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2108: -- Standard call to get message count and if count=1, get the message
2109: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
2110:
2111: WHEN OTHERS THEN
2112: ROLLBACK TO assoc_ap_pvt;

Line 2118: -- Standard call to get message count and if count=1, get the message

2114: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2115: THEN
2116: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
2117: END IF;
2118: -- Standard call to get message count and if count=1, get the message
2119: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
2120: end process_amw_ap_assoc;
2121:
2122: -- ==============================================================================

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

2207: BEGIN
2208: ---Inserting process_id
2209: SAVEPOINT process_hierarchy_count;
2210: x_return_status := fnd_api.g_ret_sts_success;
2211: -- Standard call to check for call compatibility.
2212:
2213: -- Debug Message
2214: amw_utility_pvt.debug_message ('Private API: ' || l_api_name || ' start');
2215:

Line 2277: -- Standard check for p_commit

2273: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2274: RAISE fnd_api.g_exc_error;
2275: END IF;
2276:
2277: -- Standard check for p_commit
2278: IF fnd_api.to_boolean (p_commit) THEN
2279: COMMIT WORK;
2280: END IF;
2281:

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

2280: END IF;
2281:
2282: --Debug Message
2283: amw_utility_pvt.debug_message ('Private API: ' || l_api_name || ' end');
2284: -- Standard call to get message count and if count is 1, get message info.
2285: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2286: p_data => x_msg_data);
2287:
2288: EXCEPTION

Line 2292: -- Standard call to get message count and if count=1, get the message

2288: EXCEPTION
2289: WHEN fnd_api.g_exc_error THEN
2290: ROLLBACK TO process_hierarchy_count;
2291: x_return_status := fnd_api.g_ret_sts_error;
2292: -- Standard call to get message count and if count=1, get the message
2293: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false,
2294: p_count => x_msg_count,
2295: p_data => x_msg_data
2296: );

Line 2300: -- Standard call to get message count and if count=1, get the message

2296: );
2297: WHEN fnd_api.g_exc_unexpected_error THEN
2298: ROLLBACK TO process_hierarchy_count;
2299: x_return_status := fnd_api.g_ret_sts_unexp_error;
2300: -- Standard call to get message count and if count=1, get the message
2301: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false,
2302: p_count => x_msg_count,
2303: p_data => x_msg_data
2304: );

Line 2311: -- Standard call to get message count and if count=1, get the message

2307: x_return_status := fnd_api.g_ret_sts_unexp_error;
2308: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2309: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2310: END IF;
2311: -- Standard call to get message count and if count=1, get the message
2312: fnd_msg_pub.count_and_get (p_encoded => fnd_api.g_false,
2313: p_count => x_msg_count,
2314: p_data => x_msg_data
2315: );

Line 2362: -- Standard Start of API savepoint

2358: l_object_version_number NUMBER;
2359: --l_process_rec AMW_Process_PVT.process_rec_type;
2360:
2361: BEGIN
2362: -- Standard Start of API savepoint
2363: SAVEPOINT validate_process_pvt;
2364:
2365: -- Standard call to check for call compatibility.
2366: IF NOT FND_API.Compatible_API_Call(l_api_version_number,p_api_version_number,l_api_name,G_PKG_NAME)

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

2361: BEGIN
2362: -- Standard Start of API savepoint
2363: SAVEPOINT validate_process_pvt;
2364:
2365: -- Standard call to check for call compatibility.
2366: IF NOT FND_API.Compatible_API_Call(l_api_version_number,p_api_version_number,l_api_name,G_PKG_NAME)
2367: THEN
2368: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2369: END IF;

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

2396:
2397: -- Debug Message
2398: AMW_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
2399:
2400: -- Standard call to get message count and if count is 1, get message info.
2401: FND_MSG_PUB.Count_And_Get(
2402: p_count => x_msg_count,
2403: p_data => x_msg_data
2404: );

Line 2414: -- Standard call to get message count and if count=1, get the message

2410:
2411: WHEN FND_API.G_EXC_ERROR THEN
2412: ROLLBACK TO VALIDATE_Process_pvt;
2413: x_return_status := FND_API.G_RET_STS_ERROR;
2414: -- Standard call to get message count and if count=1, get the message
2415: FND_MSG_PUB.Count_And_Get (
2416: p_encoded => FND_API.G_FALSE,
2417: p_count => x_msg_count,
2418: p_data => x_msg_data

Line 2424: -- Standard call to get message count and if count=1, get the message

2420:
2421: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2422: ROLLBACK TO VALIDATE_Process_pvt;
2423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2424: -- Standard call to get message count and if count=1, get the message
2425: FND_MSG_PUB.Count_And_Get (
2426: p_encoded => FND_API.G_FALSE,
2427: p_count => x_msg_count,
2428: p_data => x_msg_data

Line 2438: -- Standard call to get message count and if count=1, get the message

2434: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2435: THEN
2436: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2437: END IF;
2438: -- Standard call to get message count and if count=1, get the message
2439: FND_MSG_PUB.Count_And_Get (
2440: p_encoded => FND_API.G_FALSE,
2441: p_count => x_msg_count,
2442: p_data => x_msg_data

Line 2545: -- Standard call to get message count and if count=1, get the message

2541: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
2542: END IF;
2543: ----dbms_output.put_line('EXCEPTION');
2544: RAISE;
2545: -- Standard call to get message count and if count=1, get the message
2546: -- FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
2547: /*
2548: when no_data_found then
2549: return null;