APPS.IBC_CTYPE_PVT dependencies on STANDARD

Line 135: -- Standard Start of API savepoint

131: l_Does_name_exist BOOLEAN := FALSE;
132: l_Does_Description_exist BOOLEAN := FALSE;
133:
134: BEGIN
135: -- Standard Start of API savepoint
136: DBMS_TRANSACTION.SAVEPOINT(l_api_name);
137: --SAVEPOINT l_api_name;
138: -- Initialize API return status to SUCCESS
139: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

Line 380: -- Standard check for p_commit

376: --
377: -- End of API body
378: --
379:
380: -- Standard check for p_commit
381: IF Fnd_Api.to_Boolean( p_commit )
382: THEN
383: COMMIT WORK;
384: END IF;

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

382: THEN
383: COMMIT WORK;
384: END IF;
385:
386: -- Standard call to get message count and if count is 1, get message info.
387: Fnd_Msg_Pub.Count_And_Get
388: ( p_count => x_msg_count,
389: p_data => x_msg_data
390: );

Line 892: -- Standard check for p_commit

888: --
889: -- End of API body
890: --
891:
892: -- Standard check for p_commit
893: IF Fnd_Api.to_Boolean( p_commit )
894: THEN
895: COMMIT WORK;
896: END IF;

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

894: THEN
895: COMMIT WORK;
896: END IF;
897:
898: -- Standard call to get message count and if count is 1, get message info.
899: Fnd_Msg_Pub.Count_And_Get
900: ( p_count => x_msg_count,
901: p_data => x_msg_data
902: );

Line 1088: -- Standard check for p_commit

1084: --
1085: -- End of API body
1086: --
1087:
1088: -- Standard check for p_commit
1089: IF Fnd_Api.to_Boolean( p_commit )
1090: THEN
1091: COMMIT WORK;
1092: END IF;

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

1090: THEN
1091: COMMIT WORK;
1092: END IF;
1093:
1094: -- Standard call to get message count and if count is 1, get message info.
1095: Fnd_Msg_Pub.Count_And_Get
1096: ( p_count => x_msg_count,
1097: p_data => x_msg_data
1098: );

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

1523:
1524: EXECUTE IMMEDIATE 'BEGIN ' || lx_select || '; END;'
1525: USING OUT x_code, OUT x_name, OUT x_description;
1526:
1527: -- Standard call to get message count and if count is 1, get message info.
1528: Fnd_Msg_Pub.Count_And_Get
1529: ( p_count => x_msg_count,
1530: p_data => x_msg_data
1531: );

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

1725: -- dbms_output.put_line('===================END =============================');
1726: -- END LOOP;
1727: -- END IF;
1728:
1729: -- Standard call to get message count and if count is 1, get message info.
1730: Fnd_Msg_Pub.Count_And_Get
1731: ( p_count => x_msg_count,
1732: p_data => x_msg_data
1733: );

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

1948: IF C_Flex_Value_Code%NOTFOUND THEN
1949: x_exists := Fnd_Api.G_FALSE;
1950: END IF;
1951:
1952: -- Standard call to get message count and if count is 1, get message info.
1953: Fnd_Msg_Pub.Count_And_Get
1954: ( p_count => x_msg_count,
1955: p_data => x_msg_data
1956: );

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

2069: -- dbms_output.put_line(SUBSTR(x_select,1,240));
2070: -- dbms_output.put_line(SUBSTR(x_select,241,480));
2071:
2072:
2073: -- Standard call to get message count and if count is 1, get message info.
2074: Fnd_Msg_Pub.Count_And_Get
2075: ( p_count => x_msg_count,
2076: p_data => x_msg_data
2077: );