eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.POS_HZ_RELATIONSHIPS_PKG dependencies on POS_HZ_RELATIONSHIPS_PKG

Line 1: PACKAGE BODY POS_HZ_RELATIONSHIPS_PKG AS

1: PACKAGE BODY POS_HZ_RELATIONSHIPS_PKG AS
2: /*$Header: POSHZPRB.pls 120.1 2005/10/27 12:37:16 bitang noship $ */
3:
4: procedure pos_create_relationship(
5: p_subject_id IN NUMBER,

Line 103: x_exception_msg := 'POS_HZ_RELATIONSHIPS_PKG.pos_create_relationship_all_args(): Failed to object_id cannot be null';

99: l_rel_rec.created_by_module := 'POS_SUPPLIER_MGMT';
100: l_rel_rec.application_id := 177;
101:
102: if p_object_id IS NULL then
103: x_exception_msg := 'POS_HZ_RELATIONSHIPS_PKG.pos_create_relationship_all_args(): Failed to object_id cannot be null';
104: x_return_status := 'E'; /* JP changed it to 'E' from 'S' */
105: return;
106: end if;
107:

Line 109: x_exception_msg := 'POS_HZ_RELATIONSHIPS_PKG.pos_create_relationship_all_args(): Failed to subject_id cannot be null';

105: return;
106: end if;
107:
108: IF p_subject_id IS NULL THEN
109: x_exception_msg := 'POS_HZ_RELATIONSHIPS_PKG.pos_create_relationship_all_args(): Failed to subject_id cannot be null';
110: x_return_status := 'E';
111: return;
112: END IF;
113:

Line 152: raise_application_error(-20001, 'POS_HZ_RELATIONSHIPS_PKG:pos_create_relationship(): Create relationship failed :' || x_exception_msg || p_relationship_type || p_relationship_code || p_party_subject_type || p_party_object_type, true);

148: IF x_return_status <> 'S' THEN
149: -- There has been an error
150: BEGIN
151: --raise;
152: raise_application_error(-20001, 'POS_HZ_RELATIONSHIPS_PKG:pos_create_relationship(): Create relationship failed :' || x_exception_msg || p_relationship_type || p_relationship_code || p_party_subject_type || p_party_object_type, true);
153: END;
154: END IF;
155:
156: EXCEPTION

Line 158: raise_application_error(-20001, 'POS_HZ_RELATIONSHIPS_PKG:pos_create_relationship(): Create relationship failed :' || x_exception_msg || p_relationship_type || p_relationship_code || p_party_subject_type || p_party_object_type, true);

154: END IF;
155:
156: EXCEPTION
157: WHEN OTHERS THEN
158: raise_application_error(-20001, 'POS_HZ_RELATIONSHIPS_PKG:pos_create_relationship(): Create relationship failed :' || x_exception_msg || p_relationship_type || p_relationship_code || p_party_subject_type || p_party_object_type, true);
159: END pos_hz_create_relationship;
160:
161: /*
162: procedure pos_outdate_relationship_args ( p_subject_id IN NUMBER,

Line 191: x_exception_msg = 'pos_hz_relationships_pkg.pos_outdate_relationships_args():The requested relationship does not exist';

187: and subject_id = p_subject_id;
188:
189: IF l_count = 0 THEN
190: x_status = 'E'; -- Failure, because the relationship does not exist
191: x_exception_msg = 'pos_hz_relationships_pkg.pos_outdate_relationships_args():The requested relationship does not exist';
192: return;
193: END IF;
194:
195: x_exceptions_msg := 'Ending the relationship ';

Line 210: POS_UTIL_PKG.raise_error('POS_HZ_RELATIONSHIPS_PKG:pos_outdate_relationship_args():' || x_exception_msg);

206: and subject_id = p_subject_id;
207:
208: EXCEPTION
209: WHEN OTHERS THEN
210: POS_UTIL_PKG.raise_error('POS_HZ_RELATIONSHIPS_PKG:pos_outdate_relationship_args():' || x_exception_msg);
211: END;
212:
213: END pos_outdate_relationship_args;
214: */

Line 323: raise_application_error(-20001,'POS_HZ_RELATIONSHIPS_PKG:pos_outdate_relationship(): Update relationship failed :' || x_exception_msg, true);

319:
320: IF x_return_status <> 'S' THEN
321: -- There has been an error
322: BEGIN
323: raise_application_error(-20001,'POS_HZ_RELATIONSHIPS_PKG:pos_outdate_relationship(): Update relationship failed :' || x_exception_msg, true);
324: END;
325: END IF;
326:
327: EXCEPTION

Line 329: raise_application_error(-20001,'POS_HZ_RELATIONSHIPS_PKG:pos_outdate_relationship(): Update relationship failed :' || x_exception_msg,true);

325: END IF;
326:
327: EXCEPTION
328: WHEN OTHERS THEN
329: raise_application_error(-20001,'POS_HZ_RELATIONSHIPS_PKG:pos_outdate_relationship(): Update relationship failed :' || x_exception_msg,true);
330: --x_return_status := 'U';
331: --x_exception_msg := 'DEBUG: in pos_hz_relationships_pkg.update_or_insert';
332: END pos_hz_update_relationship;
333:

Line 331: --x_exception_msg := 'DEBUG: in pos_hz_relationships_pkg.update_or_insert';

327: EXCEPTION
328: WHEN OTHERS THEN
329: raise_application_error(-20001,'POS_HZ_RELATIONSHIPS_PKG:pos_outdate_relationship(): Update relationship failed :' || x_exception_msg,true);
330: --x_return_status := 'U';
331: --x_exception_msg := 'DEBUG: in pos_hz_relationships_pkg.update_or_insert';
332: END pos_hz_update_relationship;
333:
334: procedure pos_outdate_relationship(
335: p_subject_id IN NUMBER,

Line 433: x_exception_msg := 'DEBUG: POS_HZ_RELATIONSHIPS_PKG.get_relating_party_id';

429: WHEN NO_DATA_FOUND THEN
430: x_return_status := 'S'; -- No problem, a person may not have a boss!
431: WHEN OTHERS THEN
432: x_return_status := 'U';
433: x_exception_msg := 'DEBUG: POS_HZ_RELATIONSHIPS_PKG.get_relating_party_id';
434: raise_application_error(-20001, x_exception_msg, true);
435: END GET_RELATING_PARTY_ID;
436:
437:

Line 479: END POS_HZ_RELATIONSHIPS_PKG;

475: raise_application_error(-20001, x_exception_msg||' at :'
476: || l_exception_msg, true);
477: END pos_outdate_relationship;
478:
479: END POS_HZ_RELATIONSHIPS_PKG;