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

Line 244: x_msg_data := x_msg_data || ' ' || fnd_message.GET_STRING('XNB','XNB_PLS_BS_REC_IS_NULL');

240: /*
241: IF (p_bill_summaries(i) IS NULL) THEN
242: l_bs_valid_rec_flag := 'F'; -- validity is false
243: x_return_status := FND_API.G_RET_STS_ERROR;
244: x_msg_data := x_msg_data || ' ' || fnd_message.GET_STRING('XNB','XNB_PLS_BS_REC_IS_NULL');
245: fnd_message.SET_TOKEN('REC_NUM',n);
246: END IF;
247: */
248:

Line 245: fnd_message.SET_TOKEN('REC_NUM',n);

241: IF (p_bill_summaries(i) IS NULL) THEN
242: l_bs_valid_rec_flag := 'F'; -- validity is false
243: x_return_status := FND_API.G_RET_STS_ERROR;
244: x_msg_data := x_msg_data || ' ' || fnd_message.GET_STRING('XNB','XNB_PLS_BS_REC_IS_NULL');
245: fnd_message.SET_TOKEN('REC_NUM',n);
246: END IF;
247: */
248:
249: -- Bill Number is mandatory (NOT NULL field)

Line 253: x_msg_data := x_msg_data || ' ' || fnd_message.GET_STRING('XNB','XNB_PLS_BILL_NUM_IS_NULL');

249: -- Bill Number is mandatory (NOT NULL field)
250: IF (p_bill_summaries(i).BILL_NUMBER IS NULL ) THEN
251: l_bs_valid_rec_flag := 'F'; -- validity is false
252: x_return_status := FND_API.G_RET_STS_ERROR;
253: x_msg_data := x_msg_data || ' ' || fnd_message.GET_STRING('XNB','XNB_PLS_BILL_NUM_IS_NULL');
254: END IF;
255:
256: -- Account Number is mandatory (NOT NULL field)
257: IF (p_bill_summaries(i).ACCOUNT_NUMBER IS NULL) THEN

Line 260: x_msg_data := x_msg_data || ' ' || fnd_message.GET_STRING('XNB','XNB_PLS_ACC_NUM_IS_NULL');

256: -- Account Number is mandatory (NOT NULL field)
257: IF (p_bill_summaries(i).ACCOUNT_NUMBER IS NULL) THEN
258: l_bs_valid_rec_flag := 'F'; -- validity is false
259: x_return_status := FND_API.G_RET_STS_ERROR;
260: x_msg_data := x_msg_data || ' ' || fnd_message.GET_STRING('XNB','XNB_PLS_ACC_NUM_IS_NULL');
261: ELSE
262: tmp_acc_num := p_bill_summaries(i).ACCOUNT_NUMBER;
263: tmp_acc_num2 := null;
264:

Line 276: fnd_message.SET_NAME('XNB','XNB_PLS_ACC_NUM_NOT_VALID');

272: exception
273: when no_data_found then
274: l_bs_valid_rec_flag := 'F'; -- validity is false
275: x_return_status := FND_API.G_RET_STS_ERROR;
276: fnd_message.SET_NAME('XNB','XNB_PLS_ACC_NUM_NOT_VALID');
277: fnd_message.SET_TOKEN('ACC_NUM',tmp_acc_num);
278: x_msg_data := x_msg_data || ' ' || fnd_message.GET;
279: --dbms_output.put_line(' no data found= ' || l_bs_valid_rec_flag );
280: end;

Line 277: fnd_message.SET_TOKEN('ACC_NUM',tmp_acc_num);

273: when no_data_found then
274: l_bs_valid_rec_flag := 'F'; -- validity is false
275: x_return_status := FND_API.G_RET_STS_ERROR;
276: fnd_message.SET_NAME('XNB','XNB_PLS_ACC_NUM_NOT_VALID');
277: fnd_message.SET_TOKEN('ACC_NUM',tmp_acc_num);
278: x_msg_data := x_msg_data || ' ' || fnd_message.GET;
279: --dbms_output.put_line(' no data found= ' || l_bs_valid_rec_flag );
280: end;
281: close c_get_acc_num;

Line 278: x_msg_data := x_msg_data || ' ' || fnd_message.GET;

274: l_bs_valid_rec_flag := 'F'; -- validity is false
275: x_return_status := FND_API.G_RET_STS_ERROR;
276: fnd_message.SET_NAME('XNB','XNB_PLS_ACC_NUM_NOT_VALID');
277: fnd_message.SET_TOKEN('ACC_NUM',tmp_acc_num);
278: x_msg_data := x_msg_data || ' ' || fnd_message.GET;
279: --dbms_output.put_line(' no data found= ' || l_bs_valid_rec_flag );
280: end;
281: close c_get_acc_num;
282: -- Account Number must exist in eBusiness suit database

Line 291: x_msg_data := x_msg_data || ' ' || fnd_message.GET_STRING('XNB','XNB_PLS_BILL_END_DT_IS_NULL');

287: -- Bill Cycle End Date is mandatory (NOT NULL field)
288: IF (p_bill_summaries(i).BILL_CYCLE_END_DATE IS NULL) THEN
289: l_bs_valid_rec_flag := 'F'; -- validity is false
290: x_return_status := FND_API.G_RET_STS_ERROR;
291: x_msg_data := x_msg_data || ' ' || fnd_message.GET_STRING('XNB','XNB_PLS_BILL_END_DT_IS_NULL');
292: END IF;
293:
294: -- Bill Vendor Name is mandatory (NOT NULL field)
295: IF (p_bill_summaries(i).BILLING_VENDOR_NAME IS NULL) THEN

Line 298: x_msg_data := x_msg_data || ' ' || fnd_message.GET_STRING('XNB','XNB_PLS_BILL_VEN_IS_NULL');

294: -- Bill Vendor Name is mandatory (NOT NULL field)
295: IF (p_bill_summaries(i).BILLING_VENDOR_NAME IS NULL) THEN
296: l_bs_valid_rec_flag := 'F'; -- validity is false
297: x_return_status := FND_API.G_RET_STS_ERROR;
298: x_msg_data := x_msg_data || ' ' || fnd_message.GET_STRING('XNB','XNB_PLS_BILL_VEN_IS_NULL');
299: END IF;
300:
301: -- Check for Uniqe Constraints...
302: t_acc_num := p_bill_summaries(i).ACCOUNT_NUMBER;

Line 312: fnd_message.SET_NAME('XNB','XNB_PLS_BILL_SUM_REC_NOT_UNQ');

308: fetch c_check_uniq_constrain into t_uniq_val;
309: if (c_check_uniq_constrain%FOUND OR t_uniq_val ='1') then
310: l_bs_valid_rec_flag := 'F'; -- validity is false
311: x_return_status := FND_API.G_RET_STS_ERROR;
312: fnd_message.SET_NAME('XNB','XNB_PLS_BILL_SUM_REC_NOT_UNQ');
313: fnd_message.SET_TOKEN('ACC_NUM',t_acc_num);
314: fnd_message.SET_TOKEN('BILL_NUM',t_bill_num);
315: fnd_message.SET_TOKEN('BILL_VEN',t_bill_vendor);
316: x_msg_data := x_msg_data || ' ' || fnd_message.GET;

Line 313: fnd_message.SET_TOKEN('ACC_NUM',t_acc_num);

309: if (c_check_uniq_constrain%FOUND OR t_uniq_val ='1') then
310: l_bs_valid_rec_flag := 'F'; -- validity is false
311: x_return_status := FND_API.G_RET_STS_ERROR;
312: fnd_message.SET_NAME('XNB','XNB_PLS_BILL_SUM_REC_NOT_UNQ');
313: fnd_message.SET_TOKEN('ACC_NUM',t_acc_num);
314: fnd_message.SET_TOKEN('BILL_NUM',t_bill_num);
315: fnd_message.SET_TOKEN('BILL_VEN',t_bill_vendor);
316: x_msg_data := x_msg_data || ' ' || fnd_message.GET;
317: end if;

Line 314: fnd_message.SET_TOKEN('BILL_NUM',t_bill_num);

310: l_bs_valid_rec_flag := 'F'; -- validity is false
311: x_return_status := FND_API.G_RET_STS_ERROR;
312: fnd_message.SET_NAME('XNB','XNB_PLS_BILL_SUM_REC_NOT_UNQ');
313: fnd_message.SET_TOKEN('ACC_NUM',t_acc_num);
314: fnd_message.SET_TOKEN('BILL_NUM',t_bill_num);
315: fnd_message.SET_TOKEN('BILL_VEN',t_bill_vendor);
316: x_msg_data := x_msg_data || ' ' || fnd_message.GET;
317: end if;
318: exception

Line 315: fnd_message.SET_TOKEN('BILL_VEN',t_bill_vendor);

311: x_return_status := FND_API.G_RET_STS_ERROR;
312: fnd_message.SET_NAME('XNB','XNB_PLS_BILL_SUM_REC_NOT_UNQ');
313: fnd_message.SET_TOKEN('ACC_NUM',t_acc_num);
314: fnd_message.SET_TOKEN('BILL_NUM',t_bill_num);
315: fnd_message.SET_TOKEN('BILL_VEN',t_bill_vendor);
316: x_msg_data := x_msg_data || ' ' || fnd_message.GET;
317: end if;
318: exception
319: when no_data_found then

Line 316: x_msg_data := x_msg_data || ' ' || fnd_message.GET;

312: fnd_message.SET_NAME('XNB','XNB_PLS_BILL_SUM_REC_NOT_UNQ');
313: fnd_message.SET_TOKEN('ACC_NUM',t_acc_num);
314: fnd_message.SET_TOKEN('BILL_NUM',t_bill_num);
315: fnd_message.SET_TOKEN('BILL_VEN',t_bill_vendor);
316: x_msg_data := x_msg_data || ' ' || fnd_message.GET;
317: end if;
318: exception
319: when no_data_found then
320: null;

Line 479: x_msg_data := x_msg_data || ' ' || SQLERRM || ' ' || fnd_message.GET_STRING('XNB','XNB_PLS_MSG_SUCC_INS');

475: Exception
476: -- Handle null exceptions
477: WHEN null_excep THEN
478: x_return_status := FND_API.G_RET_STS_ERROR;
479: x_msg_data := x_msg_data || ' ' || SQLERRM || ' ' || fnd_message.GET_STRING('XNB','XNB_PLS_MSG_SUCC_INS');
480:
481: WHEN NO_DATA_FOUND then
482: ROLLBACK TO BULK_INSERT;
483: x_return_status := FND_API.G_RET_STS_ERROR;

Line 484: x_msg_data := x_msg_data || ' ' || SQLERRM || ' ' || fnd_message.GET_STRING('XNB','XNB_PLS_MSG_NO_REC_FND');

480:
481: WHEN NO_DATA_FOUND then
482: ROLLBACK TO BULK_INSERT;
483: x_return_status := FND_API.G_RET_STS_ERROR;
484: x_msg_data := x_msg_data || ' ' || SQLERRM || ' ' || fnd_message.GET_STRING('XNB','XNB_PLS_MSG_NO_REC_FND');
485:
486: --Date:04-Feb-2005 Author:DPUTHIYE Bug#:4159395
487: --Change: The following exception section was added to trap API version check exceptions.
488: --Other Files Impact: None.

Line 491: FND_MESSAGE.SET_NAME('XNB','XNB_PLS_MSG_INCOMPAT_API');

487: --Change: The following exception section was added to trap API version check exceptions.
488: --Other Files Impact: None.
489: WHEN FND_API.G_EXC_ERROR THEN
490: ROLLBACK TO BULK_INSERT;
491: FND_MESSAGE.SET_NAME('XNB','XNB_PLS_MSG_INCOMPAT_API');
492: FND_MESSAGE.SET_TOKEN('API_FULL_NAME', G_PKG_NAME || '.' || l_api_name );
493: FND_MESSAGE.SET_TOKEN('GIVEN_VER', p_api_version);
494: FND_MESSAGE.SET_TOKEN('CURR_VER', l_api_version);
495: x_return_status := FND_API.G_RET_STS_ERROR;

Line 492: FND_MESSAGE.SET_TOKEN('API_FULL_NAME', G_PKG_NAME || '.' || l_api_name );

488: --Other Files Impact: None.
489: WHEN FND_API.G_EXC_ERROR THEN
490: ROLLBACK TO BULK_INSERT;
491: FND_MESSAGE.SET_NAME('XNB','XNB_PLS_MSG_INCOMPAT_API');
492: FND_MESSAGE.SET_TOKEN('API_FULL_NAME', G_PKG_NAME || '.' || l_api_name );
493: FND_MESSAGE.SET_TOKEN('GIVEN_VER', p_api_version);
494: FND_MESSAGE.SET_TOKEN('CURR_VER', l_api_version);
495: x_return_status := FND_API.G_RET_STS_ERROR;
496: x_msg_data := x_msg_data || ' ' || FND_MESSAGE.GET;

Line 493: FND_MESSAGE.SET_TOKEN('GIVEN_VER', p_api_version);

489: WHEN FND_API.G_EXC_ERROR THEN
490: ROLLBACK TO BULK_INSERT;
491: FND_MESSAGE.SET_NAME('XNB','XNB_PLS_MSG_INCOMPAT_API');
492: FND_MESSAGE.SET_TOKEN('API_FULL_NAME', G_PKG_NAME || '.' || l_api_name );
493: FND_MESSAGE.SET_TOKEN('GIVEN_VER', p_api_version);
494: FND_MESSAGE.SET_TOKEN('CURR_VER', l_api_version);
495: x_return_status := FND_API.G_RET_STS_ERROR;
496: x_msg_data := x_msg_data || ' ' || FND_MESSAGE.GET;
497:

Line 494: FND_MESSAGE.SET_TOKEN('CURR_VER', l_api_version);

490: ROLLBACK TO BULK_INSERT;
491: FND_MESSAGE.SET_NAME('XNB','XNB_PLS_MSG_INCOMPAT_API');
492: FND_MESSAGE.SET_TOKEN('API_FULL_NAME', G_PKG_NAME || '.' || l_api_name );
493: FND_MESSAGE.SET_TOKEN('GIVEN_VER', p_api_version);
494: FND_MESSAGE.SET_TOKEN('CURR_VER', l_api_version);
495: x_return_status := FND_API.G_RET_STS_ERROR;
496: x_msg_data := x_msg_data || ' ' || FND_MESSAGE.GET;
497:
498: WHEN OTHERS THEN

Line 496: x_msg_data := x_msg_data || ' ' || FND_MESSAGE.GET;

492: FND_MESSAGE.SET_TOKEN('API_FULL_NAME', G_PKG_NAME || '.' || l_api_name );
493: FND_MESSAGE.SET_TOKEN('GIVEN_VER', p_api_version);
494: FND_MESSAGE.SET_TOKEN('CURR_VER', l_api_version);
495: x_return_status := FND_API.G_RET_STS_ERROR;
496: x_msg_data := x_msg_data || ' ' || FND_MESSAGE.GET;
497:
498: WHEN OTHERS THEN
499: ROLLBACK TO BULK_INSERT;
500: --Date:04-Feb-2005 Author:DPUTHIYE Bug#:4159395

Line 505: x_msg_data := x_msg_data || ' ' || SQLERRM || ' ' || fnd_message.GET_STRING('XNB','XNB_PLS_MSG_NO_REC_INS');

501: --Change: On OTHERS error, the public API should return G_RET_STS_UNEXP_ERROR. Corrected return code.
502: --Other Files Impact: None.
503: --x_return_status := FND_API.G_RET_STS_ERROR;
504: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
505: x_msg_data := x_msg_data || ' ' || SQLERRM || ' ' || fnd_message.GET_STRING('XNB','XNB_PLS_MSG_NO_REC_INS');
506:
507: End Insert_Row_Batch;
508:
509:

Line 753: x_msg_data := x_msg_data || ' ' || fnd_message.GET_STRING('XNB','XNB_PLS_BILL_NUM_IS_NULL');

749: -- Bill Number is mandatory (NOT NULL field)
750: IF (p_bill_summaries(i).BILL_NUMBER IS NULL) THEN
751: l_bs_valid_rec_flag := 'F'; -- validity is false
752: x_return_status := FND_API.G_RET_STS_ERROR;
753: x_msg_data := x_msg_data || ' ' || fnd_message.GET_STRING('XNB','XNB_PLS_BILL_NUM_IS_NULL');
754: END IF;
755:
756: -- Account Number is mandatory (NOT NULL field)
757: IF (p_bill_summaries(i).ACCOUNT_NUMBER IS NULL) THEN

Line 760: x_msg_data := x_msg_data || ' ' || fnd_message.GET_STRING('XNB','XNB_PLS_ACC_NUM_IS_NULL');

756: -- Account Number is mandatory (NOT NULL field)
757: IF (p_bill_summaries(i).ACCOUNT_NUMBER IS NULL) THEN
758: l_bs_valid_rec_flag := 'F'; -- validity is false
759: x_return_status := FND_API.G_RET_STS_ERROR;
760: x_msg_data := x_msg_data || ' ' || fnd_message.GET_STRING('XNB','XNB_PLS_ACC_NUM_IS_NULL');
761: END IF;
762:
763: -- Bill Vendor Name is mandatory (NOT NULL field)
764: IF (p_bill_summaries(i).BILLING_VENDOR_NAME IS NULL) THEN

Line 767: x_msg_data := x_msg_data || ' ' || fnd_message.GET_STRING('XNB','XNB_PLS_BILL_VEN_IS_NULL');

763: -- Bill Vendor Name is mandatory (NOT NULL field)
764: IF (p_bill_summaries(i).BILLING_VENDOR_NAME IS NULL) THEN
765: l_bs_valid_rec_flag := 'F'; -- validity is false
766: x_return_status := FND_API.G_RET_STS_ERROR;
767: x_msg_data := x_msg_data || ' ' || fnd_message.GET_STRING('XNB','XNB_PLS_BILL_VEN_IS_NULL');
768: END IF;
769:
770: -- Check for Uniqe Constraints...
771: t_acc_num := p_bill_summaries(i).ACCOUNT_NUMBER;

Line 817: fnd_message.SET_NAME('XNB','XNB_PLS_BILL_SUM_REC_UNQ');

813: when no_data_found then
814: l_bs_valid_rec_flag := 'F'; -- validity is false
815: l_bs_valid_rec_count := l_bs_valid_rec_count - 1;
816: x_return_status := FND_API.G_RET_STS_ERROR;
817: fnd_message.SET_NAME('XNB','XNB_PLS_BILL_SUM_REC_UNQ');
818: fnd_message.SET_TOKEN('ACC_NUM',t_acc_num);
819: fnd_message.SET_TOKEN('BILL_NUM',t_bill_num);
820: fnd_message.SET_TOKEN('BILL_VEN',t_bill_vendor);
821: x_msg_data := x_msg_data || ' ' || fnd_message.GET;

Line 818: fnd_message.SET_TOKEN('ACC_NUM',t_acc_num);

814: l_bs_valid_rec_flag := 'F'; -- validity is false
815: l_bs_valid_rec_count := l_bs_valid_rec_count - 1;
816: x_return_status := FND_API.G_RET_STS_ERROR;
817: fnd_message.SET_NAME('XNB','XNB_PLS_BILL_SUM_REC_UNQ');
818: fnd_message.SET_TOKEN('ACC_NUM',t_acc_num);
819: fnd_message.SET_TOKEN('BILL_NUM',t_bill_num);
820: fnd_message.SET_TOKEN('BILL_VEN',t_bill_vendor);
821: x_msg_data := x_msg_data || ' ' || fnd_message.GET;
822: end;

Line 819: fnd_message.SET_TOKEN('BILL_NUM',t_bill_num);

815: l_bs_valid_rec_count := l_bs_valid_rec_count - 1;
816: x_return_status := FND_API.G_RET_STS_ERROR;
817: fnd_message.SET_NAME('XNB','XNB_PLS_BILL_SUM_REC_UNQ');
818: fnd_message.SET_TOKEN('ACC_NUM',t_acc_num);
819: fnd_message.SET_TOKEN('BILL_NUM',t_bill_num);
820: fnd_message.SET_TOKEN('BILL_VEN',t_bill_vendor);
821: x_msg_data := x_msg_data || ' ' || fnd_message.GET;
822: end;
823: close c_check_uniq_constrain;

Line 820: fnd_message.SET_TOKEN('BILL_VEN',t_bill_vendor);

816: x_return_status := FND_API.G_RET_STS_ERROR;
817: fnd_message.SET_NAME('XNB','XNB_PLS_BILL_SUM_REC_UNQ');
818: fnd_message.SET_TOKEN('ACC_NUM',t_acc_num);
819: fnd_message.SET_TOKEN('BILL_NUM',t_bill_num);
820: fnd_message.SET_TOKEN('BILL_VEN',t_bill_vendor);
821: x_msg_data := x_msg_data || ' ' || fnd_message.GET;
822: end;
823: close c_check_uniq_constrain;
824:

Line 821: x_msg_data := x_msg_data || ' ' || fnd_message.GET;

817: fnd_message.SET_NAME('XNB','XNB_PLS_BILL_SUM_REC_UNQ');
818: fnd_message.SET_TOKEN('ACC_NUM',t_acc_num);
819: fnd_message.SET_TOKEN('BILL_NUM',t_bill_num);
820: fnd_message.SET_TOKEN('BILL_VEN',t_bill_vendor);
821: x_msg_data := x_msg_data || ' ' || fnd_message.GET;
822: end;
823: close c_check_uniq_constrain;
824:
825: -- If the bill summary record is valid

Line 988: x_msg_data := x_msg_data || ' ' || SQLERRM || ' ' || fnd_message.GET_STRING('XNB','XNB_PLS_MSG_SUCC_UPD');

984: Exception
985: -- Handle null exceptions
986: WHEN null_excep THEN
987: x_return_status := FND_API.G_RET_STS_ERROR;
988: x_msg_data := x_msg_data || ' ' || SQLERRM || ' ' || fnd_message.GET_STRING('XNB','XNB_PLS_MSG_SUCC_UPD');
989:
990: WHEN NO_DATA_FOUND then
991: ROLLBACK TO BULK_UPDATE;
992: x_return_status := FND_API.G_RET_STS_ERROR;

Line 993: x_msg_data := x_msg_data || ' ' || SQLERRM || ' ' || fnd_message.GET_STRING('XNB','XNB_PLS_MSG_ACC_BILL_NUM');

989:
990: WHEN NO_DATA_FOUND then
991: ROLLBACK TO BULK_UPDATE;
992: x_return_status := FND_API.G_RET_STS_ERROR;
993: x_msg_data := x_msg_data || ' ' || SQLERRM || ' ' || fnd_message.GET_STRING('XNB','XNB_PLS_MSG_ACC_BILL_NUM');
994:
995: --Date:04-Feb-2005 Author:DPUTHIYE Bug#:4159395
996: --Change: The following exception section was added to trap API version check exceptions.
997: --Other Files Impact: None.

Line 1000: FND_MESSAGE.SET_NAME('XNB','XNB_PLS_MSG_INCOMPAT_API');

996: --Change: The following exception section was added to trap API version check exceptions.
997: --Other Files Impact: None.
998: WHEN FND_API.G_EXC_ERROR THEN
999: ROLLBACK TO BULK_UPDATE;
1000: FND_MESSAGE.SET_NAME('XNB','XNB_PLS_MSG_INCOMPAT_API');
1001: FND_MESSAGE.SET_TOKEN('API_FULL_NAME', G_PKG_NAME || '.' || l_api_name );
1002: FND_MESSAGE.SET_TOKEN('GIVEN_VER', p_api_version);
1003: FND_MESSAGE.SET_TOKEN('CURR_VER', l_api_version);
1004: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1001: FND_MESSAGE.SET_TOKEN('API_FULL_NAME', G_PKG_NAME || '.' || l_api_name );

997: --Other Files Impact: None.
998: WHEN FND_API.G_EXC_ERROR THEN
999: ROLLBACK TO BULK_UPDATE;
1000: FND_MESSAGE.SET_NAME('XNB','XNB_PLS_MSG_INCOMPAT_API');
1001: FND_MESSAGE.SET_TOKEN('API_FULL_NAME', G_PKG_NAME || '.' || l_api_name );
1002: FND_MESSAGE.SET_TOKEN('GIVEN_VER', p_api_version);
1003: FND_MESSAGE.SET_TOKEN('CURR_VER', l_api_version);
1004: x_return_status := FND_API.G_RET_STS_ERROR;
1005: x_msg_data := x_msg_data || ' ' || FND_MESSAGE.GET;

Line 1002: FND_MESSAGE.SET_TOKEN('GIVEN_VER', p_api_version);

998: WHEN FND_API.G_EXC_ERROR THEN
999: ROLLBACK TO BULK_UPDATE;
1000: FND_MESSAGE.SET_NAME('XNB','XNB_PLS_MSG_INCOMPAT_API');
1001: FND_MESSAGE.SET_TOKEN('API_FULL_NAME', G_PKG_NAME || '.' || l_api_name );
1002: FND_MESSAGE.SET_TOKEN('GIVEN_VER', p_api_version);
1003: FND_MESSAGE.SET_TOKEN('CURR_VER', l_api_version);
1004: x_return_status := FND_API.G_RET_STS_ERROR;
1005: x_msg_data := x_msg_data || ' ' || FND_MESSAGE.GET;
1006:

Line 1003: FND_MESSAGE.SET_TOKEN('CURR_VER', l_api_version);

999: ROLLBACK TO BULK_UPDATE;
1000: FND_MESSAGE.SET_NAME('XNB','XNB_PLS_MSG_INCOMPAT_API');
1001: FND_MESSAGE.SET_TOKEN('API_FULL_NAME', G_PKG_NAME || '.' || l_api_name );
1002: FND_MESSAGE.SET_TOKEN('GIVEN_VER', p_api_version);
1003: FND_MESSAGE.SET_TOKEN('CURR_VER', l_api_version);
1004: x_return_status := FND_API.G_RET_STS_ERROR;
1005: x_msg_data := x_msg_data || ' ' || FND_MESSAGE.GET;
1006:
1007: WHEN OTHERS THEN

Line 1005: x_msg_data := x_msg_data || ' ' || FND_MESSAGE.GET;

1001: FND_MESSAGE.SET_TOKEN('API_FULL_NAME', G_PKG_NAME || '.' || l_api_name );
1002: FND_MESSAGE.SET_TOKEN('GIVEN_VER', p_api_version);
1003: FND_MESSAGE.SET_TOKEN('CURR_VER', l_api_version);
1004: x_return_status := FND_API.G_RET_STS_ERROR;
1005: x_msg_data := x_msg_data || ' ' || FND_MESSAGE.GET;
1006:
1007: WHEN OTHERS THEN
1008: ROLLBACK TO BULK_UPDATE;
1009: --Date:04-Feb-2005 Author:DPUTHIYE Bug#:4159395

Line 1014: x_msg_data := x_msg_data || ' ' || SQLERRM || ' ' || fnd_message.GET_STRING('XNB','XNB_PLS_MSG_NO_REC_UPD');

1010: --Change: On OTHERS error, the public API should return G_RET_STS_UNEXP_ERROR. Corrected return code.
1011: --Other Files Impact: None.
1012: --x_return_status := FND_API.G_RET_STS_ERROR;
1013: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1014: x_msg_data := x_msg_data || ' ' || SQLERRM || ' ' || fnd_message.GET_STRING('XNB','XNB_PLS_MSG_NO_REC_UPD');
1015:
1016: End Update_Row_Batch;
1017:
1018: