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_API

Line 43: -- -- FND_API.G_RET_STS_ERROR or FND_API.G_RET_STS_SUCCESS

39: -- IN : p_bill_summaries IN bill_summaries_table
40: -- -- The table of bill summary records to be inserted.
41: -- OUT : x_return_status OUT NOCOPY VARCHAR2
42: -- -- Execution status returned.
43: -- -- FND_API.G_RET_STS_ERROR or FND_API.G_RET_STS_SUCCESS
44: -- OUT : x_msg_data OUT NOCOPY VARCHAR2
45: -- -- Error message returned.
46: -- Version : Current version 1.0
47: -- Initial version 1.0

Line 143: IF NOT FND_API.Compatible_API_Call(

139: --Change: The following check was added to check API compatibility
140: --Other Files Impact: None.
141:
142: -- Standard call to check for call compatibility
143: IF NOT FND_API.Compatible_API_Call(
144: l_api_version,
145: p_api_version,
146: l_api_name,
147: G_PKG_NAME) THEN

Line 148: RAISE FND_API.G_EXC_ERROR;

144: l_api_version,
145: p_api_version,
146: l_api_name,
147: G_PKG_NAME) THEN
148: RAISE FND_API.G_EXC_ERROR;
149: END IF;
150:
151: -- Initialize API return status to success and other variables
152: l_bs_all_rec_count := p_bill_summaries.last;

Line 154: x_return_status := FND_API.G_RET_STS_SUCCESS;

150:
151: -- Initialize API return status to success and other variables
152: l_bs_all_rec_count := p_bill_summaries.last;
153: l_bs_valid_rec_flag := 'T';
154: x_return_status := FND_API.G_RET_STS_SUCCESS;
155: x_msg_data := null;
156:
157: -- Intialize all local varray and extend to intialize for all records
158: l_bill_summary_id :=v_number(l_num_init);

Line 243: x_return_status := FND_API.G_RET_STS_ERROR;

239: -- Record cannot be 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: */

Line 252: x_return_status := FND_API.G_RET_STS_ERROR;

248:
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)

Line 259: x_return_status := FND_API.G_RET_STS_ERROR;

255:
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;

Line 275: x_return_status := FND_API.G_RET_STS_ERROR;

271: end if;
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 );

Line 290: x_return_status := FND_API.G_RET_STS_ERROR;

286:
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)

Line 297: x_return_status := FND_API.G_RET_STS_ERROR;

293:
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...

Line 311: x_return_status := FND_API.G_RET_STS_ERROR;

307: begin
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);

Line 470: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

466: l_attribute15(i)
467: ); -- End Forall loop
468:
469: -- If Null bill number or account number throw error
470: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
471: RAISE null_excep;
472: END IF;
473:
474: -- Handle all exceptions

Line 478: x_return_status := FND_API.G_RET_STS_ERROR;

474: -- Handle all exceptions
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;

Line 483: 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;
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.

Line 489: WHEN FND_API.G_EXC_ERROR THEN

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.
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);

Line 495: x_return_status := FND_API.G_RET_STS_ERROR;

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
499: ROLLBACK TO BULK_INSERT;

Line 503: --x_return_status := FND_API.G_RET_STS_ERROR;

499: ROLLBACK TO BULK_INSERT;
500: --Date:04-Feb-2005 Author:DPUTHIYE Bug#:4159395
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;

Line 504: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

500: --Date:04-Feb-2005 Author:DPUTHIYE Bug#:4159395
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:

Line 534: -- -- FND_API.G_RET_STS_ERROR or FND_API.G_RET_STS_SUCCESS

530: -- IN : p_bill_summaries IN bill_summaries_table
531: -- -- The table of bill summary records to be inserted.
532: -- OUT : x_return_status OUT NOCOPY VARCHAR2
533: -- -- Execution status returned.
534: -- -- FND_API.G_RET_STS_ERROR or FND_API.G_RET_STS_SUCCESS
535: -- OUT : x_msg_data OUT NOCOPY VARCHAR2
536: -- -- Error message returned.
537: -- Version : Current version 1.0
538: -- Initial version 1.0

Line 653: IF NOT FND_API.Compatible_API_Call(

649: --Change: The following check was added to check API compatibility
650: --Other Files Impact: None.
651:
652: -- Standard call to check for call compatibility
653: IF NOT FND_API.Compatible_API_Call(
654: l_api_version,
655: p_api_version,
656: l_api_name,
657: G_PKG_NAME) THEN

Line 658: RAISE FND_API.G_EXC_ERROR;

654: l_api_version,
655: p_api_version,
656: l_api_name,
657: G_PKG_NAME) THEN
658: RAISE FND_API.G_EXC_ERROR;
659: END IF;
660:
661: -- Initialize API return status to success and other variables
662: l_bs_all_rec_count := p_bill_summaries.last;

Line 664: x_return_status := FND_API.G_RET_STS_SUCCESS;

660:
661: -- Initialize API return status to success and other variables
662: l_bs_all_rec_count := p_bill_summaries.last;
663: l_bs_valid_rec_flag := 'T';
664: x_return_status := FND_API.G_RET_STS_SUCCESS;
665: x_msg_data := null;
666:
667: -- Intialize all local varray and extend to intialize for all records
668: l_bill_summary_id :=v_number(l_num_init);

Line 752: x_return_status := FND_API.G_RET_STS_ERROR;

748:
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)

Line 759: x_return_status := FND_API.G_RET_STS_ERROR;

755:
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)

Line 766: x_return_status := FND_API.G_RET_STS_ERROR;

762:
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...

Line 816: x_return_status := FND_API.G_RET_STS_ERROR;

812: exception
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);

Line 979: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

975: --RAISE NO_DATA_FOUND;
976: --END IF;
977:
978: -- If Null bill number or account number or Billing Vendor Name throw error
979: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
980: RAISE null_excep;
981: END IF;
982:
983: -- Handle all exceptions

Line 987: x_return_status := FND_API.G_RET_STS_ERROR;

983: -- Handle all exceptions
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;

Line 992: 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;
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.

Line 998: WHEN FND_API.G_EXC_ERROR THEN

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.
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);

Line 1004: x_return_status := FND_API.G_RET_STS_ERROR;

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
1008: ROLLBACK TO BULK_UPDATE;

Line 1012: --x_return_status := FND_API.G_RET_STS_ERROR;

1008: ROLLBACK TO BULK_UPDATE;
1009: --Date:04-Feb-2005 Author:DPUTHIYE Bug#:4159395
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;

Line 1013: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1009: --Date:04-Feb-2005 Author:DPUTHIYE Bug#:4159395
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: