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.ARP_ACCT_EVENT_PKG dependencies on FND_MESSAGE

Line 60: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );

56: WHERE org_id = p_org_id;
57: l_org_id NUMBER;
58: BEGIN
59: IF p_start_date IS NULL THEN
60: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
61: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'p_start_date' );
62: FND_MSG_PUB.ADD;
63: x_return_status := FND_API.G_RET_STS_ERROR;
64: END IF;

Line 61: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'p_start_date' );

57: l_org_id NUMBER;
58: BEGIN
59: IF p_start_date IS NULL THEN
60: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
61: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'p_start_date' );
62: FND_MSG_PUB.ADD;
63: x_return_status := FND_API.G_RET_STS_ERROR;
64: END IF;
65:

Line 67: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );

63: x_return_status := FND_API.G_RET_STS_ERROR;
64: END IF;
65:
66: IF p_end_date IS NULL THEN
67: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
68: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'p_end_date' );
69: FND_MSG_PUB.ADD;
70: x_return_status := FND_API.G_RET_STS_ERROR;
71: END IF;

Line 68: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'p_end_date' );

64: END IF;
65:
66: IF p_end_date IS NULL THEN
67: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
68: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'p_end_date' );
69: FND_MSG_PUB.ADD;
70: x_return_status := FND_API.G_RET_STS_ERROR;
71: END IF;
72:

Line 76: fnd_message.set_name('AR', 'HZ_API_DATE_GREATER');

72:
73: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
74: IF p_start_date < p_end_date THEN
75: arp_standard.debug(' end date should be greater than the start date');
76: fnd_message.set_name('AR', 'HZ_API_DATE_GREATER');
77: fnd_message.set_token('DATE2', p_end_date);
78: fnd_message.set_token('DATE1', p_start_date);
79: fnd_msg_pub.add;
80: x_return_status := fnd_api.g_ret_sts_error;

Line 77: fnd_message.set_token('DATE2', p_end_date);

73: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
74: IF p_start_date < p_end_date THEN
75: arp_standard.debug(' end date should be greater than the start date');
76: fnd_message.set_name('AR', 'HZ_API_DATE_GREATER');
77: fnd_message.set_token('DATE2', p_end_date);
78: fnd_message.set_token('DATE1', p_start_date);
79: fnd_msg_pub.add;
80: x_return_status := fnd_api.g_ret_sts_error;
81: END IF;

Line 78: fnd_message.set_token('DATE1', p_start_date);

74: IF p_start_date < p_end_date THEN
75: arp_standard.debug(' end date should be greater than the start date');
76: fnd_message.set_name('AR', 'HZ_API_DATE_GREATER');
77: fnd_message.set_token('DATE2', p_end_date);
78: fnd_message.set_token('DATE1', p_start_date);
79: fnd_msg_pub.add;
80: x_return_status := fnd_api.g_ret_sts_error;
81: END IF;
82: END IF;

Line 88: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');

84: IF p_org_id IS NOT NULL THEN
85: OPEN c_ou(p_org_id);
86: FETCH c_ou INTO l_org_id;
87: IF c_ou%NOTFOUND THEN
88: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
89: FND_MESSAGE.SET_TOKEN('FK', 'org id');
90: FND_MESSAGE.SET_TOKEN('COLUMN', 'org_id');
91: FND_MESSAGE.SET_TOKEN('TABLE', 'ar_system_parameters_all');
92: FND_MSG_PUB.ADD;

Line 89: FND_MESSAGE.SET_TOKEN('FK', 'org id');

85: OPEN c_ou(p_org_id);
86: FETCH c_ou INTO l_org_id;
87: IF c_ou%NOTFOUND THEN
88: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
89: FND_MESSAGE.SET_TOKEN('FK', 'org id');
90: FND_MESSAGE.SET_TOKEN('COLUMN', 'org_id');
91: FND_MESSAGE.SET_TOKEN('TABLE', 'ar_system_parameters_all');
92: FND_MSG_PUB.ADD;
93: x_return_status := FND_API.G_RET_STS_ERROR;

Line 90: FND_MESSAGE.SET_TOKEN('COLUMN', 'org_id');

86: FETCH c_ou INTO l_org_id;
87: IF c_ou%NOTFOUND THEN
88: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
89: FND_MESSAGE.SET_TOKEN('FK', 'org id');
90: FND_MESSAGE.SET_TOKEN('COLUMN', 'org_id');
91: FND_MESSAGE.SET_TOKEN('TABLE', 'ar_system_parameters_all');
92: FND_MSG_PUB.ADD;
93: x_return_status := FND_API.G_RET_STS_ERROR;
94: END IF;

Line 91: FND_MESSAGE.SET_TOKEN('TABLE', 'ar_system_parameters_all');

87: IF c_ou%NOTFOUND THEN
88: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
89: FND_MESSAGE.SET_TOKEN('FK', 'org id');
90: FND_MESSAGE.SET_TOKEN('COLUMN', 'org_id');
91: FND_MESSAGE.SET_TOKEN('TABLE', 'ar_system_parameters_all');
92: FND_MSG_PUB.ADD;
93: x_return_status := FND_API.G_RET_STS_ERROR;
94: END IF;
95: CLOSE c_ou;

Line 100: FND_MESSAGE.SET_NAME( 'AR', 'AR_ONLY_VALUE_ALLOWED' );

96: END IF;
97:
98: IF p_entity = 'RA_CUST_TRX_LINE_GL_DIST_ALL' THEN
99: IF p_type NOT IN ('INV', 'CM', 'CB', 'DM', 'DEP', 'GUAR', 'ALL','INVDEPGUAR') THEN
100: FND_MESSAGE.SET_NAME( 'AR', 'AR_ONLY_VALUE_ALLOWED' );
101: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'trx_type' );
102: FND_MESSAGE.SET_TOKEN( 'VALUES', 'INV,CM,CB,DM,DEP,GUAR,ALL,INVDEPGUAR');
103: FND_MSG_PUB.ADD;
104: x_return_status := FND_API.G_RET_STS_ERROR;

Line 101: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'trx_type' );

97:
98: IF p_entity = 'RA_CUST_TRX_LINE_GL_DIST_ALL' THEN
99: IF p_type NOT IN ('INV', 'CM', 'CB', 'DM', 'DEP', 'GUAR', 'ALL','INVDEPGUAR') THEN
100: FND_MESSAGE.SET_NAME( 'AR', 'AR_ONLY_VALUE_ALLOWED' );
101: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'trx_type' );
102: FND_MESSAGE.SET_TOKEN( 'VALUES', 'INV,CM,CB,DM,DEP,GUAR,ALL,INVDEPGUAR');
103: FND_MSG_PUB.ADD;
104: x_return_status := FND_API.G_RET_STS_ERROR;
105: END IF;

Line 102: FND_MESSAGE.SET_TOKEN( 'VALUES', 'INV,CM,CB,DM,DEP,GUAR,ALL,INVDEPGUAR');

98: IF p_entity = 'RA_CUST_TRX_LINE_GL_DIST_ALL' THEN
99: IF p_type NOT IN ('INV', 'CM', 'CB', 'DM', 'DEP', 'GUAR', 'ALL','INVDEPGUAR') THEN
100: FND_MESSAGE.SET_NAME( 'AR', 'AR_ONLY_VALUE_ALLOWED' );
101: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'trx_type' );
102: FND_MESSAGE.SET_TOKEN( 'VALUES', 'INV,CM,CB,DM,DEP,GUAR,ALL,INVDEPGUAR');
103: FND_MSG_PUB.ADD;
104: x_return_status := FND_API.G_RET_STS_ERROR;
105: END IF;
106: ELSIF p_entity = 'AR_CASH_RECEIPT_HISTORY_ALL' THEN

Line 108: FND_MESSAGE.SET_NAME( 'AR', 'AR_ONLY_VALUE_ALLOWED' );

104: x_return_status := FND_API.G_RET_STS_ERROR;
105: END IF;
106: ELSIF p_entity = 'AR_CASH_RECEIPT_HISTORY_ALL' THEN
107: IF p_type NOT IN ('CASH', 'MISC', 'ALL') THEN
108: FND_MESSAGE.SET_NAME( 'AR', 'AR_ONLY_VALUE_ALLOWED' );
109: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'trx_type' );
110: FND_MESSAGE.SET_TOKEN( 'VALUES', 'CASH,MISC,ALL');
111: FND_MSG_PUB.ADD;
112: x_return_status := FND_API.G_RET_STS_ERROR;

Line 109: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'trx_type' );

105: END IF;
106: ELSIF p_entity = 'AR_CASH_RECEIPT_HISTORY_ALL' THEN
107: IF p_type NOT IN ('CASH', 'MISC', 'ALL') THEN
108: FND_MESSAGE.SET_NAME( 'AR', 'AR_ONLY_VALUE_ALLOWED' );
109: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'trx_type' );
110: FND_MESSAGE.SET_TOKEN( 'VALUES', 'CASH,MISC,ALL');
111: FND_MSG_PUB.ADD;
112: x_return_status := FND_API.G_RET_STS_ERROR;
113: END IF;

Line 110: FND_MESSAGE.SET_TOKEN( 'VALUES', 'CASH,MISC,ALL');

106: ELSIF p_entity = 'AR_CASH_RECEIPT_HISTORY_ALL' THEN
107: IF p_type NOT IN ('CASH', 'MISC', 'ALL') THEN
108: FND_MESSAGE.SET_NAME( 'AR', 'AR_ONLY_VALUE_ALLOWED' );
109: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'trx_type' );
110: FND_MESSAGE.SET_TOKEN( 'VALUES', 'CASH,MISC,ALL');
111: FND_MSG_PUB.ADD;
112: x_return_status := FND_API.G_RET_STS_ERROR;
113: END IF;
114: ELSIF p_entity = 'AR_RECEIVABLE_APPLICATIONS_ALL' THEN

Line 116: FND_MESSAGE.SET_NAME( 'AR', 'AR_ONLY_VALUE_ALLOWED' );

112: x_return_status := FND_API.G_RET_STS_ERROR;
113: END IF;
114: ELSIF p_entity = 'AR_RECEIVABLE_APPLICATIONS_ALL' THEN
115: IF p_type NOT IN ('APP', 'CMAPP', 'ALL') THEN
116: FND_MESSAGE.SET_NAME( 'AR', 'AR_ONLY_VALUE_ALLOWED' );
117: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'trx_type' );
118: FND_MESSAGE.SET_TOKEN( 'VALUES', 'APP,CMAPP,ALL');
119: FND_MSG_PUB.ADD;
120: x_return_status := FND_API.G_RET_STS_ERROR;

Line 117: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'trx_type' );

113: END IF;
114: ELSIF p_entity = 'AR_RECEIVABLE_APPLICATIONS_ALL' THEN
115: IF p_type NOT IN ('APP', 'CMAPP', 'ALL') THEN
116: FND_MESSAGE.SET_NAME( 'AR', 'AR_ONLY_VALUE_ALLOWED' );
117: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'trx_type' );
118: FND_MESSAGE.SET_TOKEN( 'VALUES', 'APP,CMAPP,ALL');
119: FND_MSG_PUB.ADD;
120: x_return_status := FND_API.G_RET_STS_ERROR;
121: END IF;

Line 118: FND_MESSAGE.SET_TOKEN( 'VALUES', 'APP,CMAPP,ALL');

114: ELSIF p_entity = 'AR_RECEIVABLE_APPLICATIONS_ALL' THEN
115: IF p_type NOT IN ('APP', 'CMAPP', 'ALL') THEN
116: FND_MESSAGE.SET_NAME( 'AR', 'AR_ONLY_VALUE_ALLOWED' );
117: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'trx_type' );
118: FND_MESSAGE.SET_TOKEN( 'VALUES', 'APP,CMAPP,ALL');
119: FND_MSG_PUB.ADD;
120: x_return_status := FND_API.G_RET_STS_ERROR;
121: END IF;
122: END IF;

Line 584: FND_MESSAGE.SET_NAME( 'AR', 'AR_ONLY_VALUE_ALLOWED' );

580: ('TRANSACTIONS','RECEIPTS',
581: 'ADJUSTMENTS', 'BILLS_RECEIVABLE')
582: THEN
583: arp_standard.debug('Value for entity code should be TRANSACTIONS RECEIPTS ADJUSTMENTS BILLS_RECEIVABLE');
584: FND_MESSAGE.SET_NAME( 'AR', 'AR_ONLY_VALUE_ALLOWED' );
585: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'ENTITY_CODE' );
586: FND_MESSAGE.SET_TOKEN( 'VALUES', 'TRANSACTIONS,RECEIPTS,ADJUSTMENTS,BILLS_RECEIVABLE');
587: FND_MSG_PUB.ADD;
588: x_return_status := FND_API.G_RET_STS_ERROR;

Line 585: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'ENTITY_CODE' );

581: 'ADJUSTMENTS', 'BILLS_RECEIVABLE')
582: THEN
583: arp_standard.debug('Value for entity code should be TRANSACTIONS RECEIPTS ADJUSTMENTS BILLS_RECEIVABLE');
584: FND_MESSAGE.SET_NAME( 'AR', 'AR_ONLY_VALUE_ALLOWED' );
585: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'ENTITY_CODE' );
586: FND_MESSAGE.SET_TOKEN( 'VALUES', 'TRANSACTIONS,RECEIPTS,ADJUSTMENTS,BILLS_RECEIVABLE');
587: FND_MSG_PUB.ADD;
588: x_return_status := FND_API.G_RET_STS_ERROR;
589: RAISE fnd_api.G_EXC_ERROR;

Line 586: FND_MESSAGE.SET_TOKEN( 'VALUES', 'TRANSACTIONS,RECEIPTS,ADJUSTMENTS,BILLS_RECEIVABLE');

582: THEN
583: arp_standard.debug('Value for entity code should be TRANSACTIONS RECEIPTS ADJUSTMENTS BILLS_RECEIVABLE');
584: FND_MESSAGE.SET_NAME( 'AR', 'AR_ONLY_VALUE_ALLOWED' );
585: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'ENTITY_CODE' );
586: FND_MESSAGE.SET_TOKEN( 'VALUES', 'TRANSACTIONS,RECEIPTS,ADJUSTMENTS,BILLS_RECEIVABLE');
587: FND_MSG_PUB.ADD;
588: x_return_status := FND_API.G_RET_STS_ERROR;
589: RAISE fnd_api.G_EXC_ERROR;
590: END IF;

Line 641: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

637: p_data => x_msg_data);
638: WHEN OTHERS THEN
639: arp_standard.debug('EXCEPTION OTHERS in upgrade_status_per_doc:'||SQLERRM);
640: x_return_status := fnd_api.g_ret_sts_unexp_error;
641: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
642: fnd_message.set_token('ERROR' ,SQLERRM);
643: fnd_msg_pub.add;
644: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
645: p_count => x_msg_count,

Line 642: fnd_message.set_token('ERROR' ,SQLERRM);

638: WHEN OTHERS THEN
639: arp_standard.debug('EXCEPTION OTHERS in upgrade_status_per_doc:'||SQLERRM);
640: x_return_status := fnd_api.g_ret_sts_unexp_error;
641: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
642: fnd_message.set_token('ERROR' ,SQLERRM);
643: fnd_msg_pub.add;
644: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
645: p_count => x_msg_count,
646: p_data => x_msg_data);

Line 703: FND_MESSAGE.SET_NAME('AR','AR_SUBMIT_ACCT_REQ');

699: IF c_adj%FOUND THEN
700: l_text := ' There is at least one adjustment not posted and does not have a xla distribution paired.
701: That is the adjustment does not have accounting created - adjustment_id :'||l_adj_id;
702: log(l_text);
703: FND_MESSAGE.SET_NAME('AR','AR_SUBMIT_ACCT_REQ');
704: FND_MSG_PUB.ADD;
705: x_return_status := FND_API.G_RET_STS_ERROR;
706: END IF;
707: CLOSE c_adj;

Line 720: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

716: p_data => x_msg_data);
717: log(x_msg_data);
718: WHEN OTHERS THEN
719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
720: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
721: FND_MESSAGE.SET_TOKEN('ERROR' ,'Insert_Head_Row:'||SQLERRM);
722: FND_MSG_PUB.ADD;
723: FND_MSG_PUB.Count_And_Get(
724: p_encoded => FND_API.G_FALSE,

Line 721: FND_MESSAGE.SET_TOKEN('ERROR' ,'Insert_Head_Row:'||SQLERRM);

717: log(x_msg_data);
718: WHEN OTHERS THEN
719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
720: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
721: FND_MESSAGE.SET_TOKEN('ERROR' ,'Insert_Head_Row:'||SQLERRM);
722: FND_MSG_PUB.ADD;
723: FND_MSG_PUB.Count_And_Get(
724: p_encoded => FND_API.G_FALSE,
725: p_count => x_msg_count,

Line 806: FND_MESSAGE.SET_NAME('AR','AR_SUBMIT_ACCT_REQ');

802: IF c_trx%FOUND THEN
803: l_text := ' There is at least one '|| l_tag ||' not posted but does not have at least xla distribution paired.
804: The '|| l_tag ||' does not have accounting created - customer_trx_id :'||l_trx_id;
805: log(l_text);
806: FND_MESSAGE.SET_NAME('AR','AR_SUBMIT_ACCT_REQ');
807: FND_MSG_PUB.ADD;
808: x_return_status := FND_API.G_RET_STS_ERROR;
809: END IF;
810: CLOSE c_trx;

Line 823: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

819: p_data => x_msg_data);
820: log(x_msg_data);
821: WHEN OTHERS THEN
822: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
823: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
824: FND_MESSAGE.SET_TOKEN('ERROR' ,'Insert_Head_Row:'||SQLERRM);
825: FND_MSG_PUB.ADD;
826: FND_MSG_PUB.Count_And_Get(
827: p_encoded => FND_API.G_FALSE,

Line 824: FND_MESSAGE.SET_TOKEN('ERROR' ,'Insert_Head_Row:'||SQLERRM);

820: log(x_msg_data);
821: WHEN OTHERS THEN
822: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
823: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
824: FND_MESSAGE.SET_TOKEN('ERROR' ,'Insert_Head_Row:'||SQLERRM);
825: FND_MSG_PUB.ADD;
826: FND_MSG_PUB.Count_And_Get(
827: p_encoded => FND_API.G_FALSE,
828: p_count => x_msg_count,

Line 900: FND_MESSAGE.SET_NAME('AR','AR_SUBMIT_ACCT_REQ');

896: IF c_recp%FOUND THEN
897: l_text := ' There is at least one '|| l_tag ||' not posted and does not have a xla distribution paired.
898: That is the '|| l_tag ||' does not have accounting created - cash_receipt_id :'||l_cr_id;
899: log(l_text);
900: FND_MESSAGE.SET_NAME('AR','AR_SUBMIT_ACCT_REQ');
901: FND_MSG_PUB.ADD;
902: x_return_status := FND_API.G_RET_STS_ERROR;
903: END IF;
904: CLOSE c_recp;

Line 917: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

913: p_data => x_msg_data);
914: log(x_msg_data);
915: WHEN OTHERS THEN
916: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
917: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
918: FND_MESSAGE.SET_TOKEN('ERROR' ,'Insert_Head_Row:'||SQLERRM);
919: FND_MSG_PUB.ADD;
920: FND_MSG_PUB.Count_And_Get(
921: p_encoded => FND_API.G_FALSE,

Line 918: FND_MESSAGE.SET_TOKEN('ERROR' ,'Insert_Head_Row:'||SQLERRM);

914: log(x_msg_data);
915: WHEN OTHERS THEN
916: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
917: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
918: FND_MESSAGE.SET_TOKEN('ERROR' ,'Insert_Head_Row:'||SQLERRM);
919: FND_MSG_PUB.ADD;
920: FND_MSG_PUB.Count_And_Get(
921: p_encoded => FND_API.G_FALSE,
922: p_count => x_msg_count,

Line 998: FND_MESSAGE.SET_NAME('AR','AR_SUBMIT_ACCT_REQ');

994: IF c_app%FOUND THEN
995: l_text := ' There is at least one '||l_tag||' not posted and does not have a xla distribution paired.
996: That is the '|| l_tag ||' does not have accounting created - receivable_application_id :'||l_ra_id;
997: log(l_text);
998: FND_MESSAGE.SET_NAME('AR','AR_SUBMIT_ACCT_REQ');
999: FND_MSG_PUB.ADD;
1000: x_return_status := FND_API.G_RET_STS_ERROR;
1001: END IF;
1002: CLOSE c_app;

Line 1015: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

1011: p_data => x_msg_data);
1012: log(x_msg_data);
1013: WHEN OTHERS THEN
1014: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1015: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1016: FND_MESSAGE.SET_TOKEN('ERROR' ,'Insert_Head_Row:'||SQLERRM);
1017: FND_MSG_PUB.ADD;
1018: FND_MSG_PUB.Count_And_Get(
1019: p_encoded => FND_API.G_FALSE,

Line 1016: FND_MESSAGE.SET_TOKEN('ERROR' ,'Insert_Head_Row:'||SQLERRM);

1012: log(x_msg_data);
1013: WHEN OTHERS THEN
1014: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1015: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1016: FND_MESSAGE.SET_TOKEN('ERROR' ,'Insert_Head_Row:'||SQLERRM);
1017: FND_MSG_PUB.ADD;
1018: FND_MSG_PUB.Count_And_Get(
1019: p_encoded => FND_API.G_FALSE,
1020: p_count => x_msg_count,

Line 1077: FND_MESSAGE.SET_NAME('AR','AR_SUBMIT_ACCT_REQ');

1073: IF c%FOUND THEN
1074: l_text := ' There is at least one bill not posted and does not have a xla distribution paired.
1075: That is the bill does not have accounting created - customer_trx_id :'||l_trx_id;
1076: log(l_text);
1077: FND_MESSAGE.SET_NAME('AR','AR_SUBMIT_ACCT_REQ');
1078: FND_MSG_PUB.ADD;
1079: x_return_status := FND_API.G_RET_STS_ERROR;
1080: END IF;
1081: CLOSE c;

Line 1094: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

1090: p_data => x_msg_data);
1091: log(x_msg_data);
1092: WHEN OTHERS THEN
1093: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1094: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1095: FND_MESSAGE.SET_TOKEN('ERROR' ,'Insert_Head_Row:'||SQLERRM);
1096: FND_MSG_PUB.ADD;
1097: FND_MSG_PUB.Count_And_Get(
1098: p_encoded => FND_API.G_FALSE,

Line 1095: FND_MESSAGE.SET_TOKEN('ERROR' ,'Insert_Head_Row:'||SQLERRM);

1091: log(x_msg_data);
1092: WHEN OTHERS THEN
1093: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1094: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1095: FND_MESSAGE.SET_TOKEN('ERROR' ,'Insert_Head_Row:'||SQLERRM);
1096: FND_MSG_PUB.ADD;
1097: FND_MSG_PUB.Count_And_Get(
1098: p_encoded => FND_API.G_FALSE,
1099: p_count => x_msg_count,

Line 1561: FND_MESSAGE.SET_NAME('AR','AR_NOT_OPEN_PERIOD_EXISTS');

1557: FETCH c_verif_date INTO l_date;
1558: IF c_verif_date%FOUND THEN
1559: x_return_status := FND_API.g_ret_sts_error;
1560: arp_standard.debug(' event_date :' || l_date);
1561: FND_MESSAGE.SET_NAME('AR','AR_NOT_OPEN_PERIOD_EXISTS');
1562: FND_MSG_PUB.ADD; --BUG#5386043
1563: END IF;
1564: CLOSE c_verif_date;
1565: