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.AHL_PARTY_MERGE_PKG dependencies on AHL_PARTY_MERGE_PKG

Line 1: PACKAGE BODY AHL_PARTY_MERGE_PKG AS

1: PACKAGE BODY AHL_PARTY_MERGE_PKG AS
2: /* $Header: AHLPMRGB.pls 115.17 2003/05/16 20:57:49 sracha noship $ */
3: -- Start of Comments
4: -- Package name : AHL_PARTY_MERGE_PKG
5: -- Purpose : Merges duplicate parties in Advanced Service

Line 4: -- Package name : AHL_PARTY_MERGE_PKG

1: PACKAGE BODY AHL_PARTY_MERGE_PKG AS
2: /* $Header: AHLPMRGB.pls 115.17 2003/05/16 20:57:49 sracha noship $ */
3: -- Start of Comments
4: -- Package name : AHL_PARTY_MERGE_PKG
5: -- Purpose : Merges duplicate parties in Advanced Service
6: -- Online tables. The
7: -- Tables that need to be considered for
8: -- Party Merge are:

Line 33: G_PROC_NAME CONSTANT VARCHAR2(30) := 'AHL_PARTY_MERGE_PKG';

29: --
30: -- End of Comments
31:
32:
33: G_PROC_NAME CONSTANT VARCHAR2(30) := 'AHL_PARTY_MERGE_PKG';
34: G_USER_ID CONSTANT NUMBER(15) := FND_GLOBAL.USER_ID;
35: G_LOGIN_ID CONSTANT NUMBER(15) := FND_GLOBAL.LOGIN_ID;
36:
37: -- Merge AHL_DOCUMENTS_B.SOURCE_PARTY_ID

Line 65: arp_message.set_line('AHL_PARTY_MERGE_PKG.AHL_DI_SOURCE_PARTY()+');

61: RESOURCE_BUSY EXCEPTION;
62: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);
63:
64: BEGIN
65: arp_message.set_line('AHL_PARTY_MERGE_PKG.AHL_DI_SOURCE_PARTY()+');
66:
67: x_return_status := FND_API.G_RET_STS_SUCCESS;
68:
69: select merge_reason_code

Line 169: arp_message.set_line('AHL_PARTY_MERGE_PKG.AHL_DI_SUPPLIER()+');

165: BEGIN
166: if ( AHL_DI_DOC_INDEX_PVT.GET_PRODUCT_INSTALL_STATUS('PO') IN ('I','S') ) then
167: return;
168: end if;
169: arp_message.set_line('AHL_PARTY_MERGE_PKG.AHL_DI_SUPPLIER()+');
170:
171: x_return_status := FND_API.G_RET_STS_SUCCESS;
172:
173: select merge_reason_code

Line 269: arp_message.set_line('AHL_PARTY_MERGE_PKG.AHL_DI_RECIPIENT_PARTY()+');

265: RESOURCE_BUSY EXCEPTION;
266: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);
267:
268: BEGIN
269: arp_message.set_line('AHL_PARTY_MERGE_PKG.AHL_DI_RECIPIENT_PARTY()+');
270:
271: x_return_status := FND_API.G_RET_STS_SUCCESS;
272:
273: select merge_reason_code

Line 372: arp_message.set_line('AHL_PARTY_MERGE_PKG.AHL_DI_REQUESTED_BY_PARTY ()+');

368: BEGIN
369: if ( AHL_DI_DOC_INDEX_PVT.GET_PRODUCT_INSTALL_STATUS('PER') IN ('I','S') ) then
370: return;
371: end if;
372: arp_message.set_line('AHL_PARTY_MERGE_PKG.AHL_DI_REQUESTED_BY_PARTY ()+');
373:
374: x_return_status := FND_API.G_RET_STS_SUCCESS;
375:
376: select merge_reason_code

Line 475: arp_message.set_line('AHL_PARTY_MERGE_PKG.AHL_DI_SUBSCRIBED_FRM_PARTY()+');

471: BEGIN
472: if ( AHL_DI_DOC_INDEX_PVT.GET_PRODUCT_INSTALL_STATUS('PO') IN ('I','S') ) then
473: return;
474: end if;
475: arp_message.set_line('AHL_PARTY_MERGE_PKG.AHL_DI_SUBSCRIBED_FRM_PARTY()+');
476:
477: x_return_status := FND_API.G_RET_STS_SUCCESS;
478:
479: select merge_reason_code

Line 579: arp_message.set_line('AHL_PARTY_MERGE_PKG.AHL_DI_APPROVED_BY_PARTY ()+');

575: if ( AHL_DI_DOC_INDEX_PVT.GET_PRODUCT_INSTALL_STATUS('PER') IN ('I','S') ) then
576: return;
577: end if;
578:
579: arp_message.set_line('AHL_PARTY_MERGE_PKG.AHL_DI_APPROVED_BY_PARTY ()+');
580:
581: x_return_status := FND_API.G_RET_STS_SUCCESS;
582:
583: select merge_reason_code

Line 679: arp_message.set_line('AHL_PARTY_MERGE_PKG.AHL_DI_RECEIVED_BY_PARTY ()+');

675: RESOURCE_BUSY EXCEPTION;
676: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);
677:
678: BEGIN
679: arp_message.set_line('AHL_PARTY_MERGE_PKG.AHL_DI_RECEIVED_BY_PARTY ()+');
680:
681: x_return_status := FND_API.G_RET_STS_SUCCESS;
682:
683: select merge_reason_code

Line 779: arp_message.set_line('AHL_PARTY_MERGE_PKG.AHL_RM_OPER_OPERATOR_PARTY ()+');

775: RESOURCE_BUSY EXCEPTION;
776: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);
777:
778: BEGIN
779: arp_message.set_line('AHL_PARTY_MERGE_PKG.AHL_RM_OPER_OPERATOR_PARTY ()+');
780:
781: x_return_status := FND_API.G_RET_STS_SUCCESS;
782:
783: select merge_reason_code

Line 876: arp_message.set_line('AHL_PARTY_MERGE_PKG.AHL_RM_OPER_H_OPERATOR_PARTY ()+');

872: RESOURCE_BUSY EXCEPTION;
873: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);
874:
875: BEGIN
876: arp_message.set_line('AHL_PARTY_MERGE_PKG.AHL_RM_OPER_H_OPERATOR_PARTY ()+');
877:
878: x_return_status := FND_API.G_RET_STS_SUCCESS;
879:
880: select merge_reason_code

Line 973: arp_message.set_line('AHL_PARTY_MERGE_PKG.AHL_RM_ROUTE_OPERATOR_PARTY ()+');

969: RESOURCE_BUSY EXCEPTION;
970: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);
971:
972: BEGIN
973: arp_message.set_line('AHL_PARTY_MERGE_PKG.AHL_RM_ROUTE_OPERATOR_PARTY ()+');
974:
975: x_return_status := FND_API.G_RET_STS_SUCCESS;
976:
977: select merge_reason_code

Line 1070: arp_message.set_line('AHL_PARTY_MERGE_PKG.AHL_RM_ROUTE_H_OPERATOR_PARTY ()+');

1066: RESOURCE_BUSY EXCEPTION;
1067: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);
1068:
1069: BEGIN
1070: arp_message.set_line('AHL_PARTY_MERGE_PKG.AHL_RM_ROUTE_H_OPERATOR_PARTY ()+');
1071:
1072: x_return_status := FND_API.G_RET_STS_SUCCESS;
1073:
1074: select merge_reason_code

Line 1168: arp_message.set_line('AHL_PARTY_MERGE_PKG.AHL_OSP_CUSTOMER()+');

1164: RESOURCE_BUSY EXCEPTION;
1165: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);
1166:
1167: BEGIN
1168: arp_message.set_line('AHL_PARTY_MERGE_PKG.AHL_OSP_CUSTOMER()+');
1169:
1170: x_return_status := FND_API.G_RET_STS_SUCCESS;
1171:
1172: select merge_reason_code

Line 1240: END AHL_PARTY_MERGE_PKG;

1236: end;
1237: end if;
1238: END AHL_OSP_CUSTOMER;
1239:
1240: END AHL_PARTY_MERGE_PKG;