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.AMW_FINSTMT_CERT_MIG_PKG dependencies on FND_API

Line 14: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

10:
11:
12: PROCEDURE POPULATE_PROC_HIERARCHY(
13: p_api_version_number IN NUMBER := 1.0,
14: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
15: p_commit IN VARCHAR2 := FND_API.g_false,
16: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
17: P_CERTIFICATION_ID NUMBER,
18: P_PROCESS_ID NUMBER,

Line 15: p_commit IN VARCHAR2 := FND_API.g_false,

11:
12: PROCEDURE POPULATE_PROC_HIERARCHY(
13: p_api_version_number IN NUMBER := 1.0,
14: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
15: p_commit IN VARCHAR2 := FND_API.g_false,
16: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
17: P_CERTIFICATION_ID NUMBER,
18: P_PROCESS_ID NUMBER,
19: P_ORGANIZATION_ID NUMBER,

Line 16: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

12: PROCEDURE POPULATE_PROC_HIERARCHY(
13: p_api_version_number IN NUMBER := 1.0,
14: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
15: p_commit IN VARCHAR2 := FND_API.g_false,
16: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
17: P_CERTIFICATION_ID NUMBER,
18: P_PROCESS_ID NUMBER,
19: P_ORGANIZATION_ID NUMBER,
20: p_account_process_flag VARCHAR2,

Line 40: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

36:
37: SAVEPOINT POPULATE_PROC_HIERARCHY;
38:
39: -- Standard call to check for call compatibility.
40: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
41: p_api_version_number,
42: l_api_name,
43: G_PKG_NAME)
44: THEN

Line 45: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

41: p_api_version_number,
42: l_api_name,
43: G_PKG_NAME)
44: THEN
45: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
46: END IF;
47:
48: -- Initialize message list if p_init_msg_list is set to TRUE.
49: IF FND_API.to_Boolean( p_init_msg_list )

Line 49: IF FND_API.to_Boolean( p_init_msg_list )

45: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
46: END IF;
47:
48: -- Initialize message list if p_init_msg_list is set to TRUE.
49: IF FND_API.to_Boolean( p_init_msg_list )
50: THEN
51: FND_MSG_PUB.initialize;
52: END IF;
53:

Line 55: x_return_status := FND_API.G_RET_STS_SUCCESS;

51: FND_MSG_PUB.initialize;
52: END IF;
53:
54: -- Initialize API return status to SUCCESS
55: x_return_status := FND_API.G_RET_STS_SUCCESS;
56:
57: SELECT COUNT(1) INTO l_count FROM AMW_FIN_PROCESS_FLAT
58: WHERE PARENT_PROCESS_ID = P_PROCESS_ID
59: AND ORGANIZATION_ID = P_ORGANIZATION_ID

Line 146: if(p_commit <> FND_API.g_false)

142: END IF;
143:
144: **********************/
145:
146: if(p_commit <> FND_API.g_false)
147: then commit;
148: end if;
149: x_return_status := FND_API.G_RET_STS_SUCCESS;
150:

Line 149: x_return_status := FND_API.G_RET_STS_SUCCESS;

145:
146: if(p_commit <> FND_API.g_false)
147: then commit;
148: end if;
149: x_return_status := FND_API.G_RET_STS_SUCCESS;
150:
151: EXCEPTION
152: WHEN NO_DATA_FOUND THEN
153: fnd_file.put_line(fnd_file.LOG, 'NO DATA FOUND IN ' || G_PKG_NAME || '.' || l_api_name );

Line 154: x_return_status := FND_API.G_RET_STS_ERROR;

150:
151: EXCEPTION
152: WHEN NO_DATA_FOUND THEN
153: fnd_file.put_line(fnd_file.LOG, 'NO DATA FOUND IN ' || G_PKG_NAME || '.' || l_api_name );
154: x_return_status := FND_API.G_RET_STS_ERROR;
155: x_msg_count := 1;
156: x_msg_data := 'NO DATA FOUND IN ' || G_PKG_NAME || '.' || l_api_name ;
157: WHEN OTHERS THEN
158: ROLLBACK TO POPULATE_PROC_HIERARCHY;

Line 161: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

157: WHEN OTHERS THEN
158: ROLLBACK TO POPULATE_PROC_HIERARCHY;
159: fnd_file.put_line(fnd_file.LOG, 'Unexpected error in ' || G_PKG_NAME || '.' || l_api_name );
160: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
161: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
162: x_msg_count := 1;
163: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
164: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
165: FND_MSG_PUB.Count_And_Get(

Line 166: p_encoded => FND_API.G_FALSE,

162: x_msg_count := 1;
163: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
164: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
165: FND_MSG_PUB.Count_And_Get(
166: p_encoded => FND_API.G_FALSE,
167: p_count => x_msg_count,
168: p_data => x_msg_data);
169: RETURN;
170:

Line 196: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

192: ----------------------------- ********************************** ----------------------
193:
194: PROCEDURE INSERT_FIN_CERT_SCOPE(
195: p_api_version_number IN NUMBER := 1.0,
196: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
197: p_commit IN VARCHAR2 := FND_API.g_false,
198: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
199: p_certification_id IN NUMBER,
200: x_return_status OUT nocopy VARCHAR2,

Line 197: p_commit IN VARCHAR2 := FND_API.g_false,

193:
194: PROCEDURE INSERT_FIN_CERT_SCOPE(
195: p_api_version_number IN NUMBER := 1.0,
196: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
197: p_commit IN VARCHAR2 := FND_API.g_false,
198: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
199: p_certification_id IN NUMBER,
200: x_return_status OUT nocopy VARCHAR2,
201: x_msg_count OUT nocopy NUMBER,

Line 198: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

194: PROCEDURE INSERT_FIN_CERT_SCOPE(
195: p_api_version_number IN NUMBER := 1.0,
196: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
197: p_commit IN VARCHAR2 := FND_API.g_false,
198: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
199: p_certification_id IN NUMBER,
200: x_return_status OUT nocopy VARCHAR2,
201: x_msg_count OUT nocopy NUMBER,
202: x_msg_data OUT nocopy VARCHAR2

Line 219: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

215:
216: SAVEPOINT INSERT_FIN_CERT_SCOPE;
217:
218: -- Standard call to check for call compatibility.
219: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
220: p_api_version_number,
221: l_api_name,
222: G_PKG_NAME)
223: THEN

Line 224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

220: p_api_version_number,
221: l_api_name,
222: G_PKG_NAME)
223: THEN
224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
225: END IF;
226:
227: -- Initialize message list if p_init_msg_list is set to TRUE.
228: IF FND_API.to_Boolean( p_init_msg_list )

Line 228: IF FND_API.to_Boolean( p_init_msg_list )

224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
225: END IF;
226:
227: -- Initialize message list if p_init_msg_list is set to TRUE.
228: IF FND_API.to_Boolean( p_init_msg_list )
229: THEN
230: FND_MSG_PUB.initialize;
231: END IF;
232:

Line 234: x_return_status := FND_API.G_RET_STS_SUCCESS;

230: FND_MSG_PUB.initialize;
231: END IF;
232:
233: -- Initialize API return status to SUCCESS
234: x_return_status := FND_API.G_RET_STS_SUCCESS;
235:
236: SELECT COUNT(1) INTO L_COUNT FROM AMW_FIN_CERT_SCOPE
237: WHERE FIN_CERTIFICATION_ID = P_CERTIFICATION_ID;
238:

Line 530: x_return_status := FND_API.G_RET_STS_SUCCESS;

526: and proc.fin_certification_id(+) = P_CERTIFICATION_ID;
527:
528: END IF;
529:
530: x_return_status := FND_API.G_RET_STS_SUCCESS;
531:
532: EXCEPTION
533: WHEN NO_DATA_FOUND THEN
534: fnd_file.put_line(fnd_file.LOG, 'NO DATA FOUND IN ' || G_PKG_NAME || '.' || l_api_name );

Line 535: x_return_status := FND_API.G_RET_STS_ERROR;

531:
532: EXCEPTION
533: WHEN NO_DATA_FOUND THEN
534: fnd_file.put_line(fnd_file.LOG, 'NO DATA FOUND IN ' || G_PKG_NAME || '.' || l_api_name );
535: x_return_status := FND_API.G_RET_STS_ERROR;
536: x_msg_count := 1;
537: x_msg_data := 'NO DATA FOUND IN ' || G_PKG_NAME || '.' || l_api_name ;
538: WHEN OTHERS THEN
539: ROLLBACK TO INSERT_FIN_CERT_SCOPE;

Line 542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

538: WHEN OTHERS THEN
539: ROLLBACK TO INSERT_FIN_CERT_SCOPE;
540: fnd_file.put_line(fnd_file.LOG, 'Unexpected error in ' || G_PKG_NAME || '.' || l_api_name );
541: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
543: x_msg_count := 1;
544: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
545: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
546: FND_MSG_PUB.Count_And_Get(

Line 547: p_encoded => FND_API.G_FALSE,

543: x_msg_count := 1;
544: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
545: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
546: FND_MSG_PUB.Count_And_Get(
547: p_encoded => FND_API.G_FALSE,
548: p_count => x_msg_count,
549: p_data => x_msg_data);
550:
551: END INSERT_FIN_CERT_SCOPE;

Line 557: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

553: ---------------------------------The following procedures are only for migration purpose------------
554: ---------------------------------name convention is the regular procedure name_M ------------------
555: PROCEDURE Populate_Fin_Risk_Ass_Sum_M(
556: p_api_version_number IN NUMBER := 1.0,
557: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
558: p_commit IN VARCHAR2 := FND_API.g_false,
559: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
560: p_certification_id IN NUMBER,
561: x_return_status OUT nocopy VARCHAR2,

Line 558: p_commit IN VARCHAR2 := FND_API.g_false,

554: ---------------------------------name convention is the regular procedure name_M ------------------
555: PROCEDURE Populate_Fin_Risk_Ass_Sum_M(
556: p_api_version_number IN NUMBER := 1.0,
557: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
558: p_commit IN VARCHAR2 := FND_API.g_false,
559: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
560: p_certification_id IN NUMBER,
561: x_return_status OUT nocopy VARCHAR2,
562: x_msg_count OUT nocopy NUMBER,

Line 559: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

555: PROCEDURE Populate_Fin_Risk_Ass_Sum_M(
556: p_api_version_number IN NUMBER := 1.0,
557: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
558: p_commit IN VARCHAR2 := FND_API.g_false,
559: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
560: p_certification_id IN NUMBER,
561: x_return_status OUT nocopy VARCHAR2,
562: x_msg_count OUT nocopy NUMBER,
563: x_msg_data OUT nocopy VARCHAR2

Line 653: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

649:
650: SAVEPOINT Populate_Fin_Risk_Ass_Sum_M;
651:
652: -- Standard call to check for call compatibility.
653: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
654: p_api_version_number,
655: l_api_name,
656: G_PKG_NAME)
657: THEN

Line 658: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

654: p_api_version_number,
655: l_api_name,
656: G_PKG_NAME)
657: THEN
658: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
659: END IF;
660:
661: -- Initialize message list if p_init_msg_list is set to TRUE.
662: IF FND_API.to_Boolean( p_init_msg_list )

Line 662: IF FND_API.to_Boolean( p_init_msg_list )

658: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
659: END IF;
660:
661: -- Initialize message list if p_init_msg_list is set to TRUE.
662: IF FND_API.to_Boolean( p_init_msg_list )
663: THEN
664: FND_MSG_PUB.initialize;
665: END IF;
666:

Line 668: x_return_status := FND_API.G_RET_STS_SUCCESS;

664: FND_MSG_PUB.initialize;
665: END IF;
666:
667: -- Initialize API return status to SUCCESS
668: x_return_status := FND_API.G_RET_STS_SUCCESS;
669:
670:
671: SELECT COUNT(1) INTO l_count FROM AMW_RISK_ASSOCIATIONS
672: WHERE object_type = 'PROCESS_FINCERT'

Line 725: if(p_commit <> FND_API.g_false)

721: risk_rec.DELETION_APPROVAL_DATE,
722: risk_rec.RISK_REV_ID);
723:
724: END LOOP;
725: if(p_commit <> FND_API.g_false)
726: then commit;
727: end if;
728:
729: END IF;

Line 730: x_return_status := FND_API.G_RET_STS_SUCCESS;

726: then commit;
727: end if;
728:
729: END IF;
730: x_return_status := FND_API.G_RET_STS_SUCCESS;
731:
732:
733: EXCEPTION
734: WHEN NO_DATA_FOUND THEN

Line 739: x_return_status := FND_API.G_RET_STS_ERROR;

735: IF c_finrisks%ISOPEN THEN
736: close c_finrisks;
737: END IF;
738: fnd_file.put_line(fnd_file.LOG, 'NO DATA FOUND IN ' || G_PKG_NAME || '.' || l_api_name );
739: x_return_status := FND_API.G_RET_STS_ERROR;
740: x_msg_count := 1;
741: x_msg_data := 'NO DATA FOUND IN ' || G_PKG_NAME || '.' || l_api_name ;
742: WHEN OTHERS THEN
743: IF c_finrisks%ISOPEN THEN

Line 749: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

745: END IF;
746: ROLLBACK TO Populate_Fin_Risk_Ass_Sum_M;
747: fnd_file.put_line(fnd_file.LOG, 'Unexpected error in ' || G_PKG_NAME || '.' || l_api_name );
748: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
749: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
750: x_msg_count := 1;
751: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
752: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
753: FND_MSG_PUB.Count_And_Get(

Line 754: p_encoded => FND_API.G_FALSE,

750: x_msg_count := 1;
751: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
752: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
753: FND_MSG_PUB.Count_And_Get(
754: p_encoded => FND_API.G_FALSE,
755: p_count => x_msg_count,
756: p_data => x_msg_data);
757: RETURN;
758:

Line 763: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

759: END Populate_Fin_Risk_Ass_Sum_M;
760:
761: PROCEDURE Populate_Fin_Ctrl_Ass_Sum_M(
762: p_api_version_number IN NUMBER := 1.0,
763: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
764: p_commit IN VARCHAR2 := FND_API.g_false,
765: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
766: p_certification_id IN NUMBER,
767: x_return_status OUT nocopy VARCHAR2,

Line 764: p_commit IN VARCHAR2 := FND_API.g_false,

760:
761: PROCEDURE Populate_Fin_Ctrl_Ass_Sum_M(
762: p_api_version_number IN NUMBER := 1.0,
763: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
764: p_commit IN VARCHAR2 := FND_API.g_false,
765: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
766: p_certification_id IN NUMBER,
767: x_return_status OUT nocopy VARCHAR2,
768: x_msg_count OUT nocopy NUMBER,

Line 765: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

761: PROCEDURE Populate_Fin_Ctrl_Ass_Sum_M(
762: p_api_version_number IN NUMBER := 1.0,
763: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
764: p_commit IN VARCHAR2 := FND_API.g_false,
765: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
766: p_certification_id IN NUMBER,
767: x_return_status OUT nocopy VARCHAR2,
768: x_msg_count OUT nocopy NUMBER,
769: x_msg_data OUT nocopy VARCHAR2

Line 859: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

855:
856: SAVEPOINT Populate_Fin_Ctrl_Ass_Sum_M;
857:
858: -- Standard call to check for call compatibility.
859: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
860: p_api_version_number,
861: l_api_name,
862: G_PKG_NAME)
863: THEN

Line 864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

860: p_api_version_number,
861: l_api_name,
862: G_PKG_NAME)
863: THEN
864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
865: END IF;
866:
867: -- Initialize message list if p_init_msg_list is set to TRUE.
868: IF FND_API.to_Boolean( p_init_msg_list )

Line 868: IF FND_API.to_Boolean( p_init_msg_list )

864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
865: END IF;
866:
867: -- Initialize message list if p_init_msg_list is set to TRUE.
868: IF FND_API.to_Boolean( p_init_msg_list )
869: THEN
870: FND_MSG_PUB.initialize;
871: END IF;
872:

Line 874: x_return_status := FND_API.G_RET_STS_SUCCESS;

870: FND_MSG_PUB.initialize;
871: END IF;
872:
873: -- Initialize API return status to SUCCESS
874: x_return_status := FND_API.G_RET_STS_SUCCESS;
875:
876:
877: SELECT COUNT(1) INTO l_count FROM AMW_CONTROL_ASSOCIATIONS
878: WHERE OBJECT_TYPE = 'RISK_FINCERT'

Line 931: if(p_commit <> FND_API.g_false)

927: control_rec.DELETION_APPROVAL_DATE,
928: control_rec.CONTROL_REV_ID);
929:
930: END LOOP;
931: if(p_commit <> FND_API.g_false)
932: then commit;
933: end if;
934: END IF;
935: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 935: x_return_status := FND_API.G_RET_STS_SUCCESS;

931: if(p_commit <> FND_API.g_false)
932: then commit;
933: end if;
934: END IF;
935: x_return_status := FND_API.G_RET_STS_SUCCESS;
936:
937: EXCEPTION
938: WHEN NO_DATA_FOUND THEN
939: IF c_fincontrols%ISOPEN THEN

Line 943: x_return_status := FND_API.G_RET_STS_ERROR;

939: IF c_fincontrols%ISOPEN THEN
940: close c_fincontrols;
941: END IF;
942: fnd_file.put_line(fnd_file.LOG, 'NO DATA FOUND IN ' || G_PKG_NAME || '.' || l_api_name );
943: x_return_status := FND_API.G_RET_STS_ERROR;
944: x_msg_count := 1;
945: x_msg_data := 'NO DATA FOUND IN ' || G_PKG_NAME || '.' || l_api_name ;
946: WHEN OTHERS THEN
947: IF c_fincontrols%ISOPEN THEN

Line 953: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

949: END IF;
950: ROLLBACK TO Populate_Fin_Ctrl_Ass_Sum_M;
951: fnd_file.put_line(fnd_file.LOG, 'Unexpected error in ' || G_PKG_NAME || '.' || l_api_name );
952: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
953: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
954: x_msg_count := 1;
955: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
956: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
957: FND_MSG_PUB.Count_And_Get(

Line 958: p_encoded => FND_API.G_FALSE,

954: x_msg_count := 1;
955: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
956: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
957: FND_MSG_PUB.Count_And_Get(
958: p_encoded => FND_API.G_FALSE,
959: p_count => x_msg_count,
960: p_data => x_msg_data);
961: RETURN;
962:

Line 969: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

965:
966: -------------populate control association which related to financial certification ----
967: PROCEDURE Populate_Fin_AP_Ass_Sum_M(
968: p_api_version_number IN NUMBER := 1.0,
969: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
970: p_commit IN VARCHAR2 := FND_API.g_false,
971: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
972: p_certification_id IN NUMBER,
973: x_return_status OUT nocopy VARCHAR2,

Line 970: p_commit IN VARCHAR2 := FND_API.g_false,

966: -------------populate control association which related to financial certification ----
967: PROCEDURE Populate_Fin_AP_Ass_Sum_M(
968: p_api_version_number IN NUMBER := 1.0,
969: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
970: p_commit IN VARCHAR2 := FND_API.g_false,
971: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
972: p_certification_id IN NUMBER,
973: x_return_status OUT nocopy VARCHAR2,
974: x_msg_count OUT nocopy NUMBER,

Line 971: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

967: PROCEDURE Populate_Fin_AP_Ass_Sum_M(
968: p_api_version_number IN NUMBER := 1.0,
969: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
970: p_commit IN VARCHAR2 := FND_API.g_false,
971: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
972: p_certification_id IN NUMBER,
973: x_return_status OUT nocopy VARCHAR2,
974: x_msg_count OUT nocopy NUMBER,
975: x_msg_data OUT nocopy VARCHAR2

Line 1065: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

1061: SAVEPOINT Populate_Fin_AP_Ass_Sum_M;
1062:
1063: -- Standard call to check for call compatibility.
1064:
1065: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1066: p_api_version_number,
1067: l_api_name,
1068: G_PKG_NAME)
1069: THEN

Line 1070: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1066: p_api_version_number,
1067: l_api_name,
1068: G_PKG_NAME)
1069: THEN
1070: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1071: END IF;
1072:
1073: -- Initialize message list if p_init_msg_list is set to TRUE.
1074: IF FND_API.to_Boolean( p_init_msg_list )

Line 1074: IF FND_API.to_Boolean( p_init_msg_list )

1070: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1071: END IF;
1072:
1073: -- Initialize message list if p_init_msg_list is set to TRUE.
1074: IF FND_API.to_Boolean( p_init_msg_list )
1075: THEN
1076: FND_MSG_PUB.initialize;
1077: END IF;
1078:

Line 1080: x_return_status := FND_API.G_RET_STS_SUCCESS;

1076: FND_MSG_PUB.initialize;
1077: END IF;
1078:
1079: -- Initialize API return status to SUCCESS
1080: x_return_status := FND_API.G_RET_STS_SUCCESS;
1081:
1082:
1083:
1084: SELECT COUNT(1) INTO l_count FROM AMW_AP_ASSOCIATIONS

Line 1140: if(p_commit <> FND_API.g_false)

1136: ap_rec.AUDIT_PROCEDURE_REV_ID);
1137:
1138:
1139: END LOOP;
1140: if(p_commit <> FND_API.g_false)
1141: then commit;
1142: end if;
1143: END IF;
1144: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1144: x_return_status := FND_API.G_RET_STS_SUCCESS;

1140: if(p_commit <> FND_API.g_false)
1141: then commit;
1142: end if;
1143: END IF;
1144: x_return_status := FND_API.G_RET_STS_SUCCESS;
1145:
1146: EXCEPTION
1147: WHEN NO_DATA_FOUND THEN
1148: IF c_finap%ISOPEN THEN

Line 1152: x_return_status := FND_API.G_RET_STS_ERROR;

1148: IF c_finap%ISOPEN THEN
1149: close c_finap;
1150: END IF;
1151: fnd_file.put_line(fnd_file.LOG, 'NO DATA FOUND IN ' || G_PKG_NAME || '.' || l_api_name );
1152: x_return_status := FND_API.G_RET_STS_ERROR;
1153: x_msg_count := 1;
1154: x_msg_data := 'NO DATA FOUND IN ' || G_PKG_NAME || '.' || l_api_name ;
1155: WHEN OTHERS THEN
1156: IF c_finap%ISOPEN THEN

Line 1162: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1158: END IF;
1159: ROLLBACK TO Populate_Fin_AP_Ass_Sum_M;
1160: fnd_file.put_line(fnd_file.LOG, 'Unexpected error in ' || G_PKG_NAME || '.' || l_api_name );
1161: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
1162: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1163: x_msg_count := 1;
1164: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
1165: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1166: FND_MSG_PUB.Count_And_Get(

Line 1167: p_encoded => FND_API.G_FALSE,

1163: x_msg_count := 1;
1164: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
1165: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1166: FND_MSG_PUB.Count_And_Get(
1167: p_encoded => FND_API.G_FALSE,
1168: p_count => x_msg_count,
1169: p_data => x_msg_data);
1170: RETURN;
1171:

Line 1441: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

1437: END Get_CONTROLS_VERIFIED_M;
1438:
1439: PROCEDURE INSERT_FIN_RISK(
1440: p_api_version_number IN NUMBER := 1.0,
1441: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1442: p_commit IN VARCHAR2 := FND_API.g_false,
1443: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
1444: p_certification_id IN NUMBER,
1445: x_return_status OUT nocopy VARCHAR2,

Line 1442: p_commit IN VARCHAR2 := FND_API.g_false,

1438:
1439: PROCEDURE INSERT_FIN_RISK(
1440: p_api_version_number IN NUMBER := 1.0,
1441: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1442: p_commit IN VARCHAR2 := FND_API.g_false,
1443: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
1444: p_certification_id IN NUMBER,
1445: x_return_status OUT nocopy VARCHAR2,
1446: x_msg_count OUT nocopy NUMBER,

Line 1443: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

1439: PROCEDURE INSERT_FIN_RISK(
1440: p_api_version_number IN NUMBER := 1.0,
1441: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1442: p_commit IN VARCHAR2 := FND_API.g_false,
1443: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
1444: p_certification_id IN NUMBER,
1445: x_return_status OUT nocopy VARCHAR2,
1446: x_msg_count OUT nocopy NUMBER,
1447: x_msg_data OUT nocopy VARCHAR2

Line 1462: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

1458: BEGIN
1459: SAVEPOINT INSERT_FIN_RISK;
1460:
1461: -- Standard call to check for call compatibility.
1462: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1463: p_api_version_number,
1464: l_api_name,
1465: G_PKG_NAME)
1466: THEN

Line 1467: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1463: p_api_version_number,
1464: l_api_name,
1465: G_PKG_NAME)
1466: THEN
1467: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1468: END IF;
1469:
1470: -- Initialize message list if p_init_msg_list is set to TRUE.
1471: IF FND_API.to_Boolean( p_init_msg_list )

Line 1471: IF FND_API.to_Boolean( p_init_msg_list )

1467: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1468: END IF;
1469:
1470: -- Initialize message list if p_init_msg_list is set to TRUE.
1471: IF FND_API.to_Boolean( p_init_msg_list )
1472: THEN
1473: FND_MSG_PUB.initialize;
1474: END IF;
1475:

Line 1477: x_return_status := FND_API.G_RET_STS_SUCCESS;

1473: FND_MSG_PUB.initialize;
1474: END IF;
1475:
1476: -- Initialize API return status to SUCCESS
1477: x_return_status := FND_API.G_RET_STS_SUCCESS;
1478:
1479: SELECT COUNT(1) INTO L_COUNT FROM AMW_FIN_ITEM_ACC_RISK
1480: WHERE FIN_CERTIFICATION_ID = P_CERTIFICATION_ID;
1481:

Line 1535: if(p_commit <> FND_API.g_false)

1531: and scp.organization_id = risk.pk2
1532: and scp.process_id = risk.pk3
1533: and risk.pk1 = p_certification_id;
1534:
1535: if(p_commit <> FND_API.g_false)
1536: then commit;
1537: end if;
1538:
1539: END IF;

Line 1540: x_return_status := FND_API.G_RET_STS_SUCCESS;

1536: then commit;
1537: end if;
1538:
1539: END IF;
1540: x_return_status := FND_API.G_RET_STS_SUCCESS;
1541: EXCEPTION
1542: WHEN NO_DATA_FOUND THEN
1543: fnd_file.put_line(fnd_file.LOG, 'NO DATA FOUND IN ' || G_PKG_NAME || '.' || l_api_name );
1544: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1544: x_return_status := FND_API.G_RET_STS_ERROR;

1540: x_return_status := FND_API.G_RET_STS_SUCCESS;
1541: EXCEPTION
1542: WHEN NO_DATA_FOUND THEN
1543: fnd_file.put_line(fnd_file.LOG, 'NO DATA FOUND IN ' || G_PKG_NAME || '.' || l_api_name );
1544: x_return_status := FND_API.G_RET_STS_ERROR;
1545: x_msg_count := 1;
1546: x_msg_data := 'NO DATA FOUND IN ' || G_PKG_NAME || '.' || l_api_name ;
1547: WHEN OTHERS THEN
1548: ROLLBACK TO INSERT_FIN_RISK;

Line 1551: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1547: WHEN OTHERS THEN
1548: ROLLBACK TO INSERT_FIN_RISK;
1549: fnd_file.put_line(fnd_file.LOG, 'Unexpected error in ' || G_PKG_NAME || '.' || l_api_name );
1550: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
1551: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1552: x_msg_count := 1;
1553: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
1554: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1555: FND_MSG_PUB.Count_And_Get(

Line 1556: p_encoded => FND_API.G_FALSE,

1552: x_msg_count := 1;
1553: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
1554: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1555: FND_MSG_PUB.Count_And_Get(
1556: p_encoded => FND_API.G_FALSE,
1557: p_count => x_msg_count,
1558: p_data => x_msg_data);
1559: RETURN;
1560:

Line 1565: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

1561: END INSERT_FIN_RISK;
1562:
1563: PROCEDURE INSERT_FIN_CTRL(
1564: p_api_version_number IN NUMBER := 1.0,
1565: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1566: p_commit IN VARCHAR2 := FND_API.g_false,
1567: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
1568: p_certification_id IN NUMBER,
1569: x_return_status OUT nocopy VARCHAR2,

Line 1566: p_commit IN VARCHAR2 := FND_API.g_false,

1562:
1563: PROCEDURE INSERT_FIN_CTRL(
1564: p_api_version_number IN NUMBER := 1.0,
1565: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1566: p_commit IN VARCHAR2 := FND_API.g_false,
1567: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
1568: p_certification_id IN NUMBER,
1569: x_return_status OUT nocopy VARCHAR2,
1570: x_msg_count OUT nocopy NUMBER,

Line 1567: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

1563: PROCEDURE INSERT_FIN_CTRL(
1564: p_api_version_number IN NUMBER := 1.0,
1565: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1566: p_commit IN VARCHAR2 := FND_API.g_false,
1567: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
1568: p_certification_id IN NUMBER,
1569: x_return_status OUT nocopy VARCHAR2,
1570: x_msg_count OUT nocopy NUMBER,
1571: x_msg_data OUT nocopy VARCHAR2

Line 1587: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

1583:
1584: SAVEPOINT INSERT_FIN_CTRL;
1585:
1586: -- Standard call to check for call compatibility.
1587: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1588: p_api_version_number,
1589: l_api_name,
1590: G_PKG_NAME)
1591: THEN

Line 1592: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1588: p_api_version_number,
1589: l_api_name,
1590: G_PKG_NAME)
1591: THEN
1592: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1593: END IF;
1594:
1595: -- Initialize message list if p_init_msg_list is set to TRUE.
1596: IF FND_API.to_Boolean( p_init_msg_list )

Line 1596: IF FND_API.to_Boolean( p_init_msg_list )

1592: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1593: END IF;
1594:
1595: -- Initialize message list if p_init_msg_list is set to TRUE.
1596: IF FND_API.to_Boolean( p_init_msg_list )
1597: THEN
1598: FND_MSG_PUB.initialize;
1599: END IF;
1600:

Line 1602: x_return_status := FND_API.G_RET_STS_SUCCESS;

1598: FND_MSG_PUB.initialize;
1599: END IF;
1600:
1601: -- Initialize API return status to SUCCESS
1602: x_return_status := FND_API.G_RET_STS_SUCCESS;
1603:
1604: SELECT COUNT(1) INTO L_COUNT FROM AMW_FIN_ITEM_ACC_CTRL
1605: WHERE FIN_CERTIFICATION_ID = P_CERTIFICATION_ID;
1606:

Line 1660: if(p_commit <> FND_API.g_false)

1656: and scp.organization_id = ctrl.pk2
1657: and scp.process_id = ctrl.pk3
1658: and ctrl.pk1 = p_certification_id;
1659:
1660: if(p_commit <> FND_API.g_false)
1661: then commit;
1662: end if;
1663:
1664: END IF;

Line 1665: x_return_status := FND_API.G_RET_STS_SUCCESS;

1661: then commit;
1662: end if;
1663:
1664: END IF;
1665: x_return_status := FND_API.G_RET_STS_SUCCESS;
1666:
1667: EXCEPTION
1668: WHEN NO_DATA_FOUND THEN
1669: fnd_file.put_line(fnd_file.LOG, 'NO DATA FOUND IN ' || G_PKG_NAME || '.' || l_api_name );

Line 1670: x_return_status := FND_API.G_RET_STS_ERROR;

1666:
1667: EXCEPTION
1668: WHEN NO_DATA_FOUND THEN
1669: fnd_file.put_line(fnd_file.LOG, 'NO DATA FOUND IN ' || G_PKG_NAME || '.' || l_api_name );
1670: x_return_status := FND_API.G_RET_STS_ERROR;
1671: x_msg_count := 1;
1672: x_msg_data := 'NO DATA FOUND IN ' || G_PKG_NAME || '.' || l_api_name ;
1673: WHEN OTHERS THEN
1674: ROLLBACK TO INSERT_FIN_CTRL;

Line 1677: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1673: WHEN OTHERS THEN
1674: ROLLBACK TO INSERT_FIN_CTRL;
1675: fnd_file.put_line(fnd_file.LOG, 'Unexpected error in ' || G_PKG_NAME || '.' || l_api_name );
1676: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
1677: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1678: x_msg_count := 1;
1679: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
1680: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1681: FND_MSG_PUB.Count_And_Get(

Line 1682: p_encoded => FND_API.G_FALSE,

1678: x_msg_count := 1;
1679: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
1680: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1681: FND_MSG_PUB.Count_And_Get(
1682: p_encoded => FND_API.G_FALSE,
1683: p_count => x_msg_count,
1684: p_data => x_msg_data);
1685: RETURN;
1686: END INSERT_FIN_CTRL;