[Home] [Help]
1994: * MODIFICATION HISTORY
1995: * 26-NOV-2001 Joe del Callar Bug 2116225: modified for
1996: * consolidated bank support.
1997: * Bug 2117973: modified to conform
1998: * to PL/SQL coding standards.
1999: * Changed selects into cursors.
2000: */
2001:
2002: PROCEDURE do_update_org_profile(
4874: l_debug_prefix VARCHAR2(30) := '';
4875:
4876: BEGIN
4877:
4878: -- standard start of API savepoint
4879: SAVEPOINT create_person;
4880:
4881: -- Check if API is called in debug mode. If yes, enable debug.
4882: --enable_debug;
4963: IF l_context = 'N' THEN
4964: hz_common_pub.enable_cont_source_security;
4965: END IF;
4966:
4967: --Standard call to get message count and if count is 1, get message info.
4968: fnd_msg_pub.count_and_get(
4969: p_encoded => fnd_api.g_false,
4970: p_count => x_msg_count,
4971: p_data => x_msg_data);
5224: l_debug_prefix VARCHAR2(30) := '';
5225:
5226: BEGIN
5227:
5228: -- standard start of API savepoint
5229: SAVEPOINT update_person;
5230:
5231: -- Check if API is called in debug mode. If yes, enable debug.
5232: --enable_debug;
5368: IF l_context = 'N' THEN
5369: hz_common_pub.enable_cont_source_security;
5370: END IF;
5371:
5372: --Standard call to get message count and if count is 1, get message info.
5373: fnd_msg_pub.count_and_get(
5374: p_encoded => fnd_api.g_false,
5375: p_count => x_msg_count,
5376: p_data => x_msg_data);
5565: l_test_security VARCHAR2(1):= 'F';
5566: l_debug_prefix VARCHAR2(30) := '';
5567: BEGIN
5568:
5569: -- standard start of API savepoint
5570: SAVEPOINT create_group;
5571:
5572: -- Check if API is called in debug mode. If yes, enable debug.
5573: --enable_debug;
5650: IF l_context = 'N' THEN
5651: hz_common_pub.enable_cont_source_security;
5652: END IF;
5653:
5654: --Standard call to get message count and if count is 1, get message info.
5655: fnd_msg_pub.count_and_get(
5656: p_encoded => fnd_api.g_false,
5657: p_count => x_msg_count,
5658: p_data => x_msg_data);
5848: l_debug_prefix VARCHAR2(30) := '';
5849:
5850: BEGIN
5851:
5852: -- standard start of API savepoint
5853: SAVEPOINT update_group;
5854:
5855: -- Check if API is called in debug mode. If yes, enable debug.
5856: --enable_debug;
5985: IF l_context = 'N' THEN
5986: hz_common_pub.enable_cont_source_security;
5987: END IF;
5988:
5989: --Standard call to get message count and if count is 1, get message info.
5990: fnd_msg_pub.count_and_get(
5991: p_encoded => fnd_api.g_false,
5992: p_count => x_msg_count,
5993: p_data => x_msg_data);
6161: * MODIFICATION HISTORY
6162: *
6163: * 07-23-2001 Indrajit Sen o Created.
6164: * 26-NOV-2001 Joe del Callar Bug 2117973: modified to conform to
6165: * PL/SQL coding standards.
6166: * Changed select...intos into cursors.
6167: *
6168: */
6169:
6190: l_debug_prefix VARCHAR2(30) := '';
6191:
6192: BEGIN
6193:
6194: -- standard start of API savepoint
6195: SAVEPOINT create_organization;
6196:
6197: -- Check if API is called in debug mode. If yes, enable debug.
6198: --enable_debug;
6315: IF l_context = 'N' THEN
6316: hz_common_pub.enable_cont_source_security;
6317: END IF;
6318:
6319: --Standard call to get message count and if count is 1, get message info.
6320: fnd_msg_pub.count_and_get(
6321: p_encoded => fnd_api.g_false,
6322: p_count => x_msg_count,
6323: p_data => x_msg_data);
6490: * MODIFICATION HISTORY
6491: *
6492: * 07-23-2001 Indrajit Sen o Created.
6493: * 26-NOV-2001 Joe del Callar Bug 2117973: modified to conform to
6494: * PL/SQL coding standards.
6495: * Changed select...intos into cursors.
6496: *
6497: */
6498:
6553: * MODIFICATION HISTORY
6554: *
6555: * 07-23-2001 Indrajit Sen o Created.
6556: * 26-NOV-2001 Joe del Callar Bug 2117973: modified to conform to
6557: * PL/SQL coding standards.
6558: * Changed select...intos into cursors.
6559: * 09-03-2002 Jyoti Pandey Added Data security Functionality
6560: *
6561: */
6590: AND hp.party_type = 'ORGANIZATION';
6591: **/
6592:
6593: BEGIN
6594: --Standard start of API savepoint
6595: SAVEPOINT update_organization;
6596:
6597: -- Check if API is called in debug mode. If yes, enable debug.
6598: --enable_debug;
6785: IF l_context = 'N' THEN
6786: hz_common_pub.enable_cont_source_security;
6787: END IF;
6788:
6789: --Standard call to get message count and if count is 1, get message info.
6790: fnd_msg_pub.count_and_get(
6791: p_encoded => fnd_api.g_false,
6792: p_count => x_msg_count,
6793: p_data => x_msg_data);
6961: * 07-23-2001 Indrajit Sen o Created.
6962: * 26-NOV-2001 Joe del Callar o Bug 2116225: modified for
6963: * consolidated bank support.
6964: * Bug 2117973: modified to conform to
6965: * PL/SQL coding standards.
6966: * Changed select...intos into cursors.
6967: *
6968: */
6969:
7239: IF l_context = 'N' THEN
7240: hz_common_pub.enable_cont_source_security;
7241: END IF;
7242:
7243: --Standard call to get message count and if count is 1, get message info.
7244: fnd_msg_pub.count_and_get(
7245: p_encoded => fnd_api.g_false,
7246: p_count => x_msg_count,
7247: p_data => x_msg_data);
7509: IF l_context = 'N' THEN
7510: hz_common_pub.enable_cont_source_security;
7511: END IF;
7512:
7513: --Standard call to get message count and if count is 1, get message info.
7514: fnd_msg_pub.count_and_get(
7515: p_encoded => fnd_api.g_false,
7516: p_count => x_msg_count,
7517: p_data => x_msg_data);
7752: x_created_by_module => x_group_rec.created_by_module,
7753: x_application_id => x_group_rec.application_id
7754: );
7755:
7756: --Standard call to get message count and if count is 1, get message info.
7757: fnd_msg_pub.count_and_get(
7758: p_encoded => fnd_api.g_false,
7759: p_count => x_msg_count,
7760: p_data => x_msg_data);
7960: x_created_by_module => l_created_by_module,
7961: x_application_id => l_application_id
7962: );
7963:
7964: --Standard call to get message count and if count is 1, get message info.
7965: fnd_msg_pub.count_and_get(
7966: p_encoded => fnd_api.g_false,
7967: p_count => x_msg_count,
7968: p_data => x_msg_data);