DBA Data[Home] [Help]

APPS.IGS_PE_PERSON_SS_PKG dependencies on STANDARD

Line 98: -- Standard Start of API savepoint

94: l_data_group IGS_PE_DATA_GROUPS.data_group%TYPE;
95: l_lvl IGS_PE_DATA_GROUPS.lvl%TYPE;
96: l_ref_notes_id igs_pe_priv_level.ref_notes_id%TYPE;
97: BEGIN
98: -- Standard Start of API savepoint
99: SAVEPOINT Update_Privacy;
100: -- Standard call to check for call compatibility.
101: IF NOT FND_API.Compatible_API_Call (l_api_version,
102: p_api_version,

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

96: l_ref_notes_id igs_pe_priv_level.ref_notes_id%TYPE;
97: BEGIN
98: -- Standard Start of API savepoint
99: SAVEPOINT Update_Privacy;
100: -- Standard call to check for call compatibility.
101: IF NOT FND_API.Compatible_API_Call (l_api_version,
102: p_api_version,
103: l_api_name,
104: G_PKG_NAME)

Line 180: -- Standard check of p_commit.

176: X_Ref_Notes_Id => l_ref_notes_id
177: );
178: END IF;
179: -- End of API body.
180: -- Standard check of p_commit.
181: IF FND_API.To_Boolean( p_commit ) THEN
182: COMMIT WORK;
183: END IF;
184: -- Standard call to get message count and if count is 1, get message info.

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

180: -- Standard check of p_commit.
181: IF FND_API.To_Boolean( p_commit ) THEN
182: COMMIT WORK;
183: END IF;
184: -- Standard call to get message count and if count is 1, get message info.
185: FND_MSG_PUB.Count_And_Get
186: ( p_count => x_msg_count ,
187: p_data => x_msg_data
188: );

Line 301: -- Standard Start of API savepoint

297: l_msg_data VARCHAR(2000);
298: l_date DATE := sysdate;
299:
300: BEGIN
301: -- Standard Start of API savepoint
302: SAVEPOINT Update_Person;
303:
304: -- Initialize message list if p_init_msg_list is set to TRUE.
305: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

383: END IF;
384: END LOOP;
385: -- End of API body.
386:
387: -- Standard call to get message count and if count is 1, get message info.
388: FND_MSG_PUB.Count_And_Get
389: ( p_count => x_msg_count ,
390: p_data => x_msg_data
391: );

Line 520: -- Standard Start of API savepoint

516: UPPER(phone_country_code||'-'||phone_area_code||'-'||phone_number||'-'||phone_extension) = UPPER(cp_phone_number);
517:
518: dup_phone_rec dup_phone_cur%ROWTYPE;
519: BEGIN
520: -- Standard Start of API savepoint
521: SAVEPOINT Update_Phone;
522: -- Standard call to check for call compatibility.
523: IF NOT FND_API.Compatible_API_Call (l_api_version,
524: p_api_version,

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

518: dup_phone_rec dup_phone_cur%ROWTYPE;
519: BEGIN
520: -- Standard Start of API savepoint
521: SAVEPOINT Update_Phone;
522: -- Standard call to check for call compatibility.
523: IF NOT FND_API.Compatible_API_Call (l_api_version,
524: p_api_version,
525: l_api_name,
526: G_PKG_NAME)

Line 708: -- Standard check of p_commit.

704: END IF;
705: END IF;
706: x_id := l_contact_point_id;
707: -- End of API body.
708: -- Standard check of p_commit.
709: IF FND_API.To_Boolean( p_commit ) THEN
710: COMMIT WORK;
711: END IF;
712: -- Standard call to get message count and if count is 1, get message info.

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

708: -- Standard check of p_commit.
709: IF FND_API.To_Boolean( p_commit ) THEN
710: COMMIT WORK;
711: END IF;
712: -- Standard call to get message count and if count is 1, get message info.
713: FND_MSG_PUB.Count_And_Get
714: ( p_count => x_msg_count ,
715: p_data => x_msg_data
716: );

Line 834: -- Standard Start of API savepoint

830: dup_addrs_rec dup_addrs_cur%ROWTYPE;
831:
832:
833: BEGIN
834: -- Standard Start of API savepoint
835: SAVEPOINT Update_Usage;
836: -- Standard call to check for call compatibility.
837: IF NOT FND_API.Compatible_API_Call (l_api_version,
838: p_api_version,

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

832:
833: BEGIN
834: -- Standard Start of API savepoint
835: SAVEPOINT Update_Usage;
836: -- Standard call to check for call compatibility.
837: IF NOT FND_API.Compatible_API_Call (l_api_version,
838: p_api_version,
839: l_api_name,
840: G_PKG_NAME)

Line 890: -- Standard check of p_commit.

886: raise FND_API.G_EXC_ERROR;
887: END IF;
888: x_id := l_party_site_use_id;
889: -- End of API body.
890: -- Standard check of p_commit.
891: IF FND_API.To_Boolean( p_commit ) THEN
892: COMMIT WORK;
893: END IF;
894: -- Standard call to get message count and if count is 1, get message info.

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

890: -- Standard check of p_commit.
891: IF FND_API.To_Boolean( p_commit ) THEN
892: COMMIT WORK;
893: END IF;
894: -- Standard call to get message count and if count is 1, get message info.
895: FND_MSG_PUB.Count_And_Get
896: ( p_count => x_msg_count ,
897: p_data => x_msg_data
898: );

Line 973: -- Standard Start of API savepoint

969: employed_by_party_id
970: FROM igs_ad_emp_dtl
971: WHERE employment_history_id = p_employment_history_id;
972: BEGIN
973: -- Standard Start of API savepoint
974: SAVEPOINT Update_Employment;
975: -- Standard call to check for call compatibility.
976: IF NOT FND_API.Compatible_API_Call (l_api_version,
977: p_api_version,

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

971: WHERE employment_history_id = p_employment_history_id;
972: BEGIN
973: -- Standard Start of API savepoint
974: SAVEPOINT Update_Employment;
975: -- Standard call to check for call compatibility.
976: IF NOT FND_API.Compatible_API_Call (l_api_version,
977: p_api_version,
978: l_api_name,
979: G_PKG_NAME)

Line 1078: -- Standard check of p_commit.

1074: END LOOP;
1075: END IF;
1076: x_id := l_employment_history_id;
1077: -- End of API body.
1078: -- Standard check of p_commit.
1079: IF FND_API.To_Boolean( p_commit ) THEN
1080: COMMIT WORK;
1081: END IF;
1082: -- Standard call to get message count and if count is 1, get message info.

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

1078: -- Standard check of p_commit.
1079: IF FND_API.To_Boolean( p_commit ) THEN
1080: COMMIT WORK;
1081: END IF;
1082: -- Standard call to get message count and if count is 1, get message info.
1083: FND_MSG_PUB.Count_And_Get
1084: ( p_count => x_msg_count ,
1085: p_data => x_msg_data
1086: );

Line 1173: -- Standard Start of API savepoint

1169:
1170: -- l_stdnt_ps_attempt_dtls_rec c_get_stdnt_ps_att_dtls%ROWTYPE;
1171:
1172: BEGIN
1173: -- Standard Start of API savepoint
1174: SAVEPOINT Update_Dates;
1175: -- Standard call to check for call compatibility.
1176: IF NOT FND_API.Compatible_API_Call (l_api_version,
1177: p_api_version,

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

1171:
1172: BEGIN
1173: -- Standard Start of API savepoint
1174: SAVEPOINT Update_Dates;
1175: -- Standard call to check for call compatibility.
1176: IF NOT FND_API.Compatible_API_Call (l_api_version,
1177: p_api_version,
1178: l_api_name,
1179: G_PKG_NAME)

Line 1349: -- Standard check of p_commit.

1345: );
1346: END LOOP;
1347: END IF;
1348: -- End of API body.
1349: -- Standard check of p_commit.
1350: IF FND_API.To_Boolean( p_commit ) THEN
1351: COMMIT WORK;
1352: END IF;
1353: -- Standard call to get message count and if count is 1, get message info.

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

1349: -- Standard check of p_commit.
1350: IF FND_API.To_Boolean( p_commit ) THEN
1351: COMMIT WORK;
1352: END IF;
1353: -- Standard call to get message count and if count is 1, get message info.
1354: FND_MSG_PUB.Count_And_Get
1355: ( p_count => x_msg_count ,
1356: p_data => x_msg_data
1357: );

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

1717: END IF;
1718: end if;
1719: -- End of API body.
1720:
1721: -- Standard call to get message count and if count is 1, get message info.
1722:
1723: EXCEPTION
1724: WHEN OTHERS THEN
1725: ROLLBACK TO Update_Biographic;