[Home] [Help]
2035: * MODIFICATION HISTORY
2036: * 26-NOV-2001 Joe del Callar Bug 2116225: modified for
2037: * consolidated bank support.
2038: * Bug 2117973: modified to conform
2039: * to PL/SQL coding standards.
2040: * Changed selects into cursors.
2041: */
2042:
2043: PROCEDURE do_update_org_profile(
4934: l_debug_prefix VARCHAR2(30) := '';
4935:
4936: BEGIN
4937:
4938: -- standard start of API savepoint
4939: SAVEPOINT create_person;
4940:
4941: -- Check if API is called in debug mode. If yes, enable debug.
4942: --enable_debug;
5023: IF l_context = 'N' THEN
5024: hz_common_pub.enable_cont_source_security;
5025: END IF;
5026:
5027: --Standard call to get message count and if count is 1, get message info.
5028: fnd_msg_pub.count_and_get(
5029: p_encoded => fnd_api.g_false,
5030: p_count => x_msg_count,
5031: p_data => x_msg_data);
5286: l_debug_prefix VARCHAR2(30) := '';
5287:
5288: BEGIN
5289:
5290: -- standard start of API savepoint
5291: SAVEPOINT update_person;
5292:
5293: -- Check if API is called in debug mode. If yes, enable debug.
5294: --enable_debug;
5439: IF l_context = 'N' THEN
5440: hz_common_pub.enable_cont_source_security;
5441: END IF;
5442:
5443: --Standard call to get message count and if count is 1, get message info.
5444: fnd_msg_pub.count_and_get(
5445: p_encoded => fnd_api.g_false,
5446: p_count => x_msg_count,
5447: p_data => x_msg_data);
5636: l_test_security VARCHAR2(1):= 'F';
5637: l_debug_prefix VARCHAR2(30) := '';
5638: BEGIN
5639:
5640: -- standard start of API savepoint
5641: SAVEPOINT create_group;
5642:
5643: -- Check if API is called in debug mode. If yes, enable debug.
5644: --enable_debug;
5721: IF l_context = 'N' THEN
5722: hz_common_pub.enable_cont_source_security;
5723: END IF;
5724:
5725: --Standard call to get message count and if count is 1, get message info.
5726: fnd_msg_pub.count_and_get(
5727: p_encoded => fnd_api.g_false,
5728: p_count => x_msg_count,
5729: p_data => x_msg_data);
5919: l_debug_prefix VARCHAR2(30) := '';
5920:
5921: BEGIN
5922:
5923: -- standard start of API savepoint
5924: SAVEPOINT update_group;
5925:
5926: -- Check if API is called in debug mode. If yes, enable debug.
5927: --enable_debug;
6056: IF l_context = 'N' THEN
6057: hz_common_pub.enable_cont_source_security;
6058: END IF;
6059:
6060: --Standard call to get message count and if count is 1, get message info.
6061: fnd_msg_pub.count_and_get(
6062: p_encoded => fnd_api.g_false,
6063: p_count => x_msg_count,
6064: p_data => x_msg_data);
6232: * MODIFICATION HISTORY
6233: *
6234: * 07-23-2001 Indrajit Sen o Created.
6235: * 26-NOV-2001 Joe del Callar Bug 2117973: modified to conform to
6236: * PL/SQL coding standards.
6237: * Changed select...intos into cursors.
6238: *
6239: */
6240:
6261: l_debug_prefix VARCHAR2(30) := '';
6262:
6263: BEGIN
6264:
6265: -- standard start of API savepoint
6266: SAVEPOINT create_organization;
6267:
6268: -- Check if API is called in debug mode. If yes, enable debug.
6269: --enable_debug;
6386: IF l_context = 'N' THEN
6387: hz_common_pub.enable_cont_source_security;
6388: END IF;
6389:
6390: --Standard call to get message count and if count is 1, get message info.
6391: fnd_msg_pub.count_and_get(
6392: p_encoded => fnd_api.g_false,
6393: p_count => x_msg_count,
6394: p_data => x_msg_data);
6561: * MODIFICATION HISTORY
6562: *
6563: * 07-23-2001 Indrajit Sen o Created.
6564: * 26-NOV-2001 Joe del Callar Bug 2117973: modified to conform to
6565: * PL/SQL coding standards.
6566: * Changed select...intos into cursors.
6567: *
6568: */
6569:
6624: * MODIFICATION HISTORY
6625: *
6626: * 07-23-2001 Indrajit Sen o Created.
6627: * 26-NOV-2001 Joe del Callar Bug 2117973: modified to conform to
6628: * PL/SQL coding standards.
6629: * Changed select...intos into cursors.
6630: * 09-03-2002 Jyoti Pandey Added Data security Functionality
6631: *
6632: * 30-06-2010 Sudhir Gokavarapu Bug9735521 - When Actual Content Source is NULL
6663: AND hp.party_type = 'ORGANIZATION';
6664: **/
6665:
6666: BEGIN
6667: --Standard start of API savepoint
6668: SAVEPOINT update_organization;
6669:
6670: -- Check if API is called in debug mode. If yes, enable debug.
6671: --enable_debug;
6866: IF l_context = 'N' THEN
6867: hz_common_pub.enable_cont_source_security;
6868: END IF;
6869:
6870: --Standard call to get message count and if count is 1, get message info.
6871: fnd_msg_pub.count_and_get(
6872: p_encoded => fnd_api.g_false,
6873: p_count => x_msg_count,
6874: p_data => x_msg_data);
7042: * 07-23-2001 Indrajit Sen o Created.
7043: * 26-NOV-2001 Joe del Callar o Bug 2116225: modified for
7044: * consolidated bank support.
7045: * Bug 2117973: modified to conform to
7046: * PL/SQL coding standards.
7047: * Changed select...intos into cursors.
7048: *
7049: */
7050:
7351: IF l_context = 'N' THEN
7352: hz_common_pub.enable_cont_source_security;
7353: END IF;
7354:
7355: --Standard call to get message count and if count is 1, get message info.
7356: fnd_msg_pub.count_and_get(
7357: p_encoded => fnd_api.g_false,
7358: p_count => x_msg_count,
7359: p_data => x_msg_data);
7621: IF l_context = 'N' THEN
7622: hz_common_pub.enable_cont_source_security;
7623: END IF;
7624:
7625: --Standard call to get message count and if count is 1, get message info.
7626: fnd_msg_pub.count_and_get(
7627: p_encoded => fnd_api.g_false,
7628: p_count => x_msg_count,
7629: p_data => x_msg_data);
7864: x_created_by_module => x_group_rec.created_by_module,
7865: x_application_id => x_group_rec.application_id
7866: );
7867:
7868: --Standard call to get message count and if count is 1, get message info.
7869: fnd_msg_pub.count_and_get(
7870: p_encoded => fnd_api.g_false,
7871: p_count => x_msg_count,
7872: p_data => x_msg_data);
8072: x_created_by_module => l_created_by_module,
8073: x_application_id => l_application_id
8074: );
8075:
8076: --Standard call to get message count and if count is 1, get message info.
8077: fnd_msg_pub.count_and_get(
8078: p_encoded => fnd_api.g_false,
8079: p_count => x_msg_count,
8080: p_data => x_msg_data);