DBA Data[Home] [Help]

APPS.EDR_PSIG dependencies on FND_API

Line 546: p_init_msg_list => FND_API.G_TRUE ,

542: -- ack status for this erecord as its just created in the step above
543:
544: EDR_TRANS_ACKN_PVT.INSERT_ROW
545: ( p_api_version => 1.0 ,
546: p_init_msg_list => FND_API.G_TRUE ,
547: p_validation_level => FND_API.G_VALID_LEVEL_NONE ,
548: x_return_status => l_return_status ,
549: x_msg_count => l_msg_count ,
550: x_msg_data => l_msg_data ,

Line 547: p_validation_level => FND_API.G_VALID_LEVEL_NONE ,

543:
544: EDR_TRANS_ACKN_PVT.INSERT_ROW
545: ( p_api_version => 1.0 ,
546: p_init_msg_list => FND_API.G_TRUE ,
547: p_validation_level => FND_API.G_VALID_LEVEL_NONE ,
548: x_return_status => l_return_status ,
549: x_msg_count => l_msg_count ,
550: x_msg_data => l_msg_data ,
551: p_erecord_id => l_document_id ,

Line 558: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

554: p_ackn_note => null ,
555: x_ackn_id => l_ackn_id
556: );
557:
558: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
559: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
560: END IF;
561:
562: EXCEPTION

Line 559: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

555: x_ackn_id => l_ackn_id
556: );
557:
558: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
559: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
560: END IF;
561:
562: EXCEPTION
563: WHEN EDR_GENERIC_ERROR then

Line 565: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

561:
562: EXCEPTION
563: WHEN EDR_GENERIC_ERROR then
564: NULL;
565: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
566: FND_MSG_PUB.Count_And_Get
567: ( p_count => l_msg_count ,
568: p_data => l_msg_data
569: );

Line 685: p_init_msg_list => FND_API.G_TRUE ,

681: -- ack status for this erecord as its just created in the step above
682:
683: EDR_TRANS_ACKN_PVT.INSERT_ROW
684: ( p_api_version => 1.0 ,
685: p_init_msg_list => FND_API.G_TRUE ,
686: p_validation_level => FND_API.G_VALID_LEVEL_NONE ,
687: x_return_status => l_return_status ,
688: x_msg_count => l_msg_count ,
689: x_msg_data => l_msg_data ,

Line 686: p_validation_level => FND_API.G_VALID_LEVEL_NONE ,

682:
683: EDR_TRANS_ACKN_PVT.INSERT_ROW
684: ( p_api_version => 1.0 ,
685: p_init_msg_list => FND_API.G_TRUE ,
686: p_validation_level => FND_API.G_VALID_LEVEL_NONE ,
687: x_return_status => l_return_status ,
688: x_msg_count => l_msg_count ,
689: x_msg_data => l_msg_data ,
690: p_erecord_id => l_document_id ,

Line 697: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

693: p_ackn_note => null ,
694: x_ackn_id => l_ackn_id
695: );
696:
697: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
698: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
699: END IF;
700:
701: EXCEPTION

Line 698: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

694: x_ackn_id => l_ackn_id
695: );
696:
697: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
698: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
699: END IF;
700:
701: EXCEPTION
702: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 702: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

698: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
699: END IF;
700:
701: EXCEPTION
702: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
703: FND_MSG_PUB.Count_And_Get
704: ( p_count => l_msg_count ,
705: p_data => l_msg_data
706: );

Line 2781: if(FND_API.TO_BOOLEAN(p_get_erecord_xml)) then

2777: --Copy the same to the result variable.
2778: select xmlconcat(l_result,l_current_xml) into l_result from dual;
2779:
2780: --Fetch the psig_xml if required.
2781: if(FND_API.TO_BOOLEAN(p_get_erecord_xml)) then
2782:
2783: l_current_xml := GET_ERECORD_XML(p_document_id => l_parent_erecord_id);
2784:
2785: --Append the psig_xml into the result variable.

Line 2791: if(FND_API.TO_BOOLEAN(p_get_psig_details)) then

2787:
2788: end if;
2789:
2790: --Fetch the signature details if required.
2791: if(FND_API.TO_BOOLEAN(p_get_psig_details)) then
2792:
2793: l_current_xml := GET_PSIG_DETAIL_XML(p_document_id => l_parent_erecord_id);
2794:
2795: --Append the signature details

Line 2799: if(FND_API.TO_BOOLEAN(p_get_ackn_details)) then

2795: --Append the signature details
2796: select xmlconcat(l_result,l_current_xml) into l_result from dual;
2797: end if;
2798:
2799: if(FND_API.TO_BOOLEAN(p_get_ackn_details)) then
2800:
2801: l_current_xml := get_ackn_detail_xml(p_document_id => l_parent_erecord_id);
2802:
2803: --Append the acknowledgement details.

Line 2808: if(FND_API.TO_BOOLEAN(p_get_print_details)) then

2804: select xmlconcat(l_result,l_current_xml) into l_result from dual;
2805:
2806: end if;
2807:
2808: if(FND_API.TO_BOOLEAN(p_get_print_details)) then
2809: l_current_xml := get_print_history_detail_xml(p_document_id => l_parent_erecord_id);
2810: select xmlconcat(l_result,l_current_xml) into l_result from dual;
2811: end if;
2812:

Line 2957: if(FND_API.TO_BOOLEAN(p_get_erecord_xml)) then

2953: l_current_xml := get_erecord_header_xml(p_document_id => l_child_erecord_ids(i));
2954:
2955: l_result_xml_tbl(i) := l_current_xml;
2956:
2957: if(FND_API.TO_BOOLEAN(p_get_erecord_xml)) then
2958: l_current_xml := GET_ERECORD_XML(p_document_id => l_child_erecord_ids(i));
2959: select xmlconcat(l_result_xml_tbl(i),l_current_xml) into l_result_xml_tbl(i) from dual;
2960: end if;
2961:

Line 2962: if(FND_API.TO_BOOLEAN(p_get_psig_details)) then

2958: l_current_xml := GET_ERECORD_XML(p_document_id => l_child_erecord_ids(i));
2959: select xmlconcat(l_result_xml_tbl(i),l_current_xml) into l_result_xml_tbl(i) from dual;
2960: end if;
2961:
2962: if(FND_API.TO_BOOLEAN(p_get_psig_details)) then
2963: l_current_xml := GET_PSIG_DETAIL_XML(p_document_id => l_child_erecord_ids(i));
2964: select xmlconcat(l_result_xml_tbl(i),l_current_xml) into l_result_xml_tbl(i) from dual;
2965: end if;
2966:

Line 2967: if(FND_API.TO_BOOLEAN(p_get_ackn_details)) then

2963: l_current_xml := GET_PSIG_DETAIL_XML(p_document_id => l_child_erecord_ids(i));
2964: select xmlconcat(l_result_xml_tbl(i),l_current_xml) into l_result_xml_tbl(i) from dual;
2965: end if;
2966:
2967: if(FND_API.TO_BOOLEAN(p_get_ackn_details)) then
2968: l_current_xml := get_ackn_detail_xml(p_document_id => l_child_erecord_ids(i));
2969: select xmlconcat(l_result_xml_tbl(i),l_current_xml) into l_result_xml_tbl(i) from dual;
2970: end if;
2971:

Line 2972: if(FND_API.TO_BOOLEAN(p_get_print_details)) then

2968: l_current_xml := get_ackn_detail_xml(p_document_id => l_child_erecord_ids(i));
2969: select xmlconcat(l_result_xml_tbl(i),l_current_xml) into l_result_xml_tbl(i) from dual;
2970: end if;
2971:
2972: if(FND_API.TO_BOOLEAN(p_get_print_details)) then
2973: l_current_xml := get_print_history_detail_xml(p_document_id => l_child_erecord_ids(i));
2974: select xmlconcat(l_result_xml_tbl(i),l_current_xml) into l_result_xml_tbl(i) from dual;
2975: end if;
2976:

Line 3027: if(FND_API.TO_BOOLEAN(p_get_erecord_xml)) then

3023:
3024: select xmlconcat(l_current_result,l_current_xml) into l_current_result from dual;
3025:
3026: --If the psig_xml is required, fetch the same in XML format.
3027: if(FND_API.TO_BOOLEAN(p_get_erecord_xml)) then
3028: l_current_xml := GET_ERECORD_XML(p_document_id => p_erecord_ids(i));
3029: select xmlconcat(l_current_result,l_current_xml) into l_current_result from dual;
3030: end if;
3031:

Line 3033: if(FND_API.TO_BOOLEAN(p_get_psig_details)) then

3029: select xmlconcat(l_current_result,l_current_xml) into l_current_result from dual;
3030: end if;
3031:
3032: --If the signature details are required, fetch the same in XML format.
3033: if(FND_API.TO_BOOLEAN(p_get_psig_details)) then
3034: l_current_xml := GET_PSIG_DETAIL_XML(p_document_id => p_erecord_ids(i));
3035: select xmlconcat(l_current_result,l_current_xml) into l_current_result from dual;
3036: end if;
3037:

Line 3039: if(FND_API.TO_BOOLEAN(p_get_ackn_details)) then

3035: select xmlconcat(l_current_result,l_current_xml) into l_current_result from dual;
3036: end if;
3037:
3038: --If the acknowledgement details are required, fetch the same in XML format.
3039: if(FND_API.TO_BOOLEAN(p_get_ackn_details)) then
3040: l_current_xml := get_ackn_detail_xml(p_document_id => p_erecord_ids(i));
3041: select xmlconcat(l_current_result,l_current_xml) into l_current_result from dual;
3042: end if;
3043:

Line 3045: if(FND_API.TO_BOOLEAN(p_get_print_details)) then

3041: select xmlconcat(l_current_result,l_current_xml) into l_current_result from dual;
3042: end if;
3043:
3044: --If the print history details are required, fetch the same in XML format.
3045: if(FND_API.TO_BOOLEAN(p_get_print_details)) then
3046: l_current_xml := get_print_history_detail_xml(p_document_id => p_erecord_ids(i));
3047: select xmlconcat(l_current_result,l_current_xml) into l_current_result from dual;
3048: end if;
3049:

Line 3051: if(FND_API.TO_BOOLEAN(p_get_related_erec_details)) then

3047: select xmlconcat(l_current_result,l_current_xml) into l_current_result from dual;
3048: end if;
3049:
3050: --If the related e-record details are required, fetch the same in XML format.
3051: if(FND_API.TO_BOOLEAN(p_get_related_erec_details)) then
3052: l_current_xml := get_parent_erecord_detail_xml(p_document_id => p_erecord_ids(i),
3053: P_GET_ERECORD_XML => P_GET_ERECORD_XML,
3054: P_GET_PSIG_DETAILS => P_GET_PSIG_DETAILS,
3055: P_GET_ACKN_DETAILS => P_GET_ACKN_DETAILS,