DBA Data[Home] [Help]

APPS.OKC_PHI_PVT dependencies on FND_API

Line 303: l_MODIFIER_LIST_rec.description := ltrim(rtrim(Fnd_Msg_Pub.Get( p_msg_index => Fnd_Msg_Pub.G_LAST, p_encoded => FND_API.G_FALSE ))); --Modifier Name Transalated

299: p_token1_value => l_k_header.contract_number,
300: p_token2 => 'KMODIFIER',
301: p_token2_value => nvl(l_k_header.contract_number_modifier,' '));
302:
303: l_MODIFIER_LIST_rec.description := ltrim(rtrim(Fnd_Msg_Pub.Get( p_msg_index => Fnd_Msg_Pub.G_LAST, p_encoded => FND_API.G_FALSE ))); --Modifier Name Transalated
304: l_MODIFIER_LIST_rec.name := l_modifier_list_rec.description;
305:
306: l_MODIFIER_LIST_rec.version_no := '0.1';
307: l_MODIFIER_LIST_rec.operation := QP_GLOBALS.G_OPR_CREATE;

Line 811: ,p_init_msg_list => FND_API.G_FALSE

807: okc_util.print_trace(2,'Calling QP_Modifiers_PUB.proces_modifiers');
808: END IF;
809:
810: QP_Modifiers_PUB.Process_Modifiers(p_api_version_number => 1.0
811: ,p_init_msg_list => FND_API.G_FALSE
812: ,p_return_values => FND_API.G_FALSE
813: ,p_commit => FND_API.G_FALSE
814: ,x_return_status => l_return_status
815: ,x_msg_count => x_msg_count

Line 812: ,p_return_values => FND_API.G_FALSE

808: END IF;
809:
810: QP_Modifiers_PUB.Process_Modifiers(p_api_version_number => 1.0
811: ,p_init_msg_list => FND_API.G_FALSE
812: ,p_return_values => FND_API.G_FALSE
813: ,p_commit => FND_API.G_FALSE
814: ,x_return_status => l_return_status
815: ,x_msg_count => x_msg_count
816: ,x_msg_data => x_msg_data

Line 813: ,p_commit => FND_API.G_FALSE

809:
810: QP_Modifiers_PUB.Process_Modifiers(p_api_version_number => 1.0
811: ,p_init_msg_list => FND_API.G_FALSE
812: ,p_return_values => FND_API.G_FALSE
813: ,p_commit => FND_API.G_FALSE
814: ,x_return_status => l_return_status
815: ,x_msg_count => x_msg_count
816: ,x_msg_data => x_msg_data
817: ,p_MODIFIER_LIST_rec => l_MODIFIER_LIST_rec

Line 839: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

835: IF (l_debug = 'Y') THEN
836: okc_util.print_trace(2,'List Header Id '||l_x_MODIFIER_LIST_rec.list_header_id);
837: END IF;
838:
839: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
840:
841: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
842:
843: END IF;

Line 841: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

837: END IF;
838:
839: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
840:
841: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
842:
843: END IF;
844:
845:

Line 894: p_init_msg_list => FND_API.G_FALSE,

890: okc_util.print_trace(2,'Start OKC_CONTRACT_PUB.update_contract_line');
891: END IF;
892:
893: OKC_CONTRACT_PUB.update_contract_line( p_api_version => 1.0,
894: p_init_msg_list => FND_API.G_FALSE,
895: x_return_status => l_return_status,
896: x_msg_count => x_msg_count,
897: x_msg_data => x_msg_data,
898: p_restricted_update => OKC_API.G_TRUE,

Line 907: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

903: okc_util.print_trace(2,'End OKC_CONTRACT_PUB.update_contract_line:Status'||l_return_status);
904: END IF;
905:
906:
907: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
908:
909: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
910:
911: END IF;

Line 909: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

905:
906:
907: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
908:
909: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
910:
911: END IF;
912:
913: END IF;

Line 921: p_init_msg_list => FND_API.G_FALSE,

917: IF (l_debug = 'Y') THEN
918: okc_util.print_trace(2,'Start OKC_PHL_PVT.update_row');
919: END IF;
920: OKC_PHL_PVT.update_row( p_api_version => 1.0,
921: p_init_msg_list => FND_API.G_FALSE,
922: x_return_status => l_return_status,
923: x_msg_count => x_msg_count,
924: x_msg_data => x_msg_data,
925: p_okc_ph_line_breaks_v_tbl =>l_ph_line_breaks_tbl,

Line 932: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

928: okc_util.print_trace(2,'End OKC_PHL_PVT.update_row:Status'||l_return_status);
929: END IF;
930:
931:
932: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
933:
934: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
935:
936: END IF;

Line 934: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

930:
931:
932: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
933:
934: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
935:
936: END IF;
937:
938: END IF;

Line 979: ,p_init_msg_list => FND_API.G_FALSE

975: okc_util.print_trace(2,'Calling QP_Modifiers_proces_modifiers');
976: END IF;
977:
978: QP_Modifiers_PUB.Process_Modifiers (p_api_version_number => 1.0
979: ,p_init_msg_list => FND_API.G_FALSE
980: ,p_return_values => FND_API.G_FALSE
981: ,p_commit => FND_API.G_FALSE
982: ,x_return_status => l_return_status
983: ,x_msg_count =>x_msg_count

Line 980: ,p_return_values => FND_API.G_FALSE

976: END IF;
977:
978: QP_Modifiers_PUB.Process_Modifiers (p_api_version_number => 1.0
979: ,p_init_msg_list => FND_API.G_FALSE
980: ,p_return_values => FND_API.G_FALSE
981: ,p_commit => FND_API.G_FALSE
982: ,x_return_status => l_return_status
983: ,x_msg_count =>x_msg_count
984: ,x_msg_data => x_msg_data

Line 981: ,p_commit => FND_API.G_FALSE

977:
978: QP_Modifiers_PUB.Process_Modifiers (p_api_version_number => 1.0
979: ,p_init_msg_list => FND_API.G_FALSE
980: ,p_return_values => FND_API.G_FALSE
981: ,p_commit => FND_API.G_FALSE
982: ,x_return_status => l_return_status
983: ,x_msg_count =>x_msg_count
984: ,x_msg_data => x_msg_data
985: ,p_MODIFIER_LIST_rec => l_MODIFIER_LIST_rec

Line 1003: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

999: okc_util.print_trace(2,'Exited QP_Modifiers_proces_modifiers, Status '||l_return_status);
1000: okc_util.print_trace(2,'List Header Id '||l_x_MODIFIER_LIST_rec.list_header_id);
1001: END IF;
1002:
1003: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1004: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1005: END IF;
1006: END IF;
1007:

Line 1004: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1000: okc_util.print_trace(2,'List Header Id '||l_x_MODIFIER_LIST_rec.list_header_id);
1001: END IF;
1002:
1003: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1004: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1005: END IF;
1006: END IF;
1007:
1008: END IF;

Line 1017: x_return_status := FND_API.G_RET_STS_SUCCESS;

1013: END IF;
1014:
1015: CLOSE c_k_header;
1016:
1017: x_return_status := FND_API.G_RET_STS_SUCCESS;
1018:
1019: EXCEPTION
1020:
1021: WHEN FND_API.G_EXC_ERROR THEN

Line 1021: WHEN FND_API.G_EXC_ERROR THEN

1017: x_return_status := FND_API.G_RET_STS_SUCCESS;
1018:
1019: EXCEPTION
1020:
1021: WHEN FND_API.G_EXC_ERROR THEN
1022: -- transferring error messages from QP to FND error stack
1023: FOR i in 1..x_msg_count LOOP
1024: x_msg_data := oe_msg_pub.get(p_msg_index => i,
1025: p_encoded => 'F'

Line 1058: x_return_status := FND_API.G_RET_STS_ERROR;

1054:
1055: IF c_ph_header_qual%ISOPEN THEN
1056: CLOSE c_ph_header_qual;
1057: END IF;
1058: x_return_status := FND_API.G_RET_STS_ERROR;
1059:
1060: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1061:
1062: FOR i in 1..x_msg_count LOOP

Line 1060: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1056: CLOSE c_ph_header_qual;
1057: END IF;
1058: x_return_status := FND_API.G_RET_STS_ERROR;
1059:
1060: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1061:
1062: FOR i in 1..x_msg_count LOOP
1063: x_msg_data := oe_msg_pub.get(p_msg_index => i,
1064: p_encoded => 'F'

Line 1097: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1093:
1094: IF c_ph_header_qual%ISOPEN THEN
1095: CLOSE c_ph_header_qual;
1096: END IF;
1097: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1098:
1099:
1100: WHEN OTHERS THEN
1101:

Line 1136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1132:
1133: if c_ph_header_qual%ISOPEN then
1134: CLOSE c_ph_header_qual;
1135: end if;
1136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1137:
1138: END;
1139:
1140:

Line 1307: ,p_init_msg_list => FND_API.G_FALSE

1303: END IF;
1304:
1305:
1306: QP_Modifiers_PUB.Process_Modifiers (p_api_version_number => 1.0
1307: ,p_init_msg_list => FND_API.G_FALSE
1308: ,p_return_values => FND_API.G_FALSE
1309: ,p_commit => FND_API.G_FALSE
1310: ,x_return_status => l_return_status
1311: ,x_msg_count =>x_msg_count

Line 1308: ,p_return_values => FND_API.G_FALSE

1304:
1305:
1306: QP_Modifiers_PUB.Process_Modifiers (p_api_version_number => 1.0
1307: ,p_init_msg_list => FND_API.G_FALSE
1308: ,p_return_values => FND_API.G_FALSE
1309: ,p_commit => FND_API.G_FALSE
1310: ,x_return_status => l_return_status
1311: ,x_msg_count =>x_msg_count
1312: ,x_msg_data => x_msg_data

Line 1309: ,p_commit => FND_API.G_FALSE

1305:
1306: QP_Modifiers_PUB.Process_Modifiers (p_api_version_number => 1.0
1307: ,p_init_msg_list => FND_API.G_FALSE
1308: ,p_return_values => FND_API.G_FALSE
1309: ,p_commit => FND_API.G_FALSE
1310: ,x_return_status => l_return_status
1311: ,x_msg_count =>x_msg_count
1312: ,x_msg_data => x_msg_data
1313: ,p_MODIFIER_LIST_rec => l_MODIFIER_LIST_rec

Line 1332: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1328: okc_util.print_trace(2,'Exited QP_Modifiers_proces_modifiers, Status '||l_return_status);
1329: okc_util.print_trace(2,'List Header Id '||l_x_MODIFIER_LIST_rec.list_header_id);
1330: END IF;
1331:
1332: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1334: END IF;
1335: END IF;
1336: END IF; -- IF c_ph_header%FOUND Then

Line 1333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1329: okc_util.print_trace(2,'List Header Id '||l_x_MODIFIER_LIST_rec.list_header_id);
1330: END IF;
1331:
1332: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1334: END IF;
1335: END IF;
1336: END IF; -- IF c_ph_header%FOUND Then
1337: CLOSE c_ph_header;

Line 1342: x_return_status := FND_API.G_RET_STS_SUCCESS;

1338:
1339: END IF; -- IF c_k_header%FOUND then
1340:
1341: close c_k_header;
1342: x_return_status := FND_API.G_RET_STS_SUCCESS;
1343:
1344: EXCEPTION
1345:
1346: WHEN FND_API.G_EXC_ERROR THEN

Line 1346: WHEN FND_API.G_EXC_ERROR THEN

1342: x_return_status := FND_API.G_RET_STS_SUCCESS;
1343:
1344: EXCEPTION
1345:
1346: WHEN FND_API.G_EXC_ERROR THEN
1347:
1348: FOR i in 1..x_msg_count LOOP
1349: x_msg_data := oe_msg_pub.get(p_msg_index => i,
1350: p_encoded => 'F'

Line 1376: x_return_status := FND_API.G_RET_STS_ERROR;

1372: if c_ph_line_break%ISOPEN then
1373: CLOSE c_ph_line_break;
1374: end if;
1375:
1376: x_return_status := FND_API.G_RET_STS_ERROR;
1377:
1378: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1379:
1380: FOR i in 1..x_msg_count LOOP

Line 1378: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1374: end if;
1375:
1376: x_return_status := FND_API.G_RET_STS_ERROR;
1377:
1378: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1379:
1380: FOR i in 1..x_msg_count LOOP
1381: x_msg_data := oe_msg_pub.get(p_msg_index => i,
1382: p_encoded => 'F'

Line 1408: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1404: if c_ph_line_break%ISOPEN then
1405: CLOSE c_ph_line_break;
1406: end if;
1407:
1408: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1409:
1410:
1411: WHEN OTHERS THEN
1412:

Line 1441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1437: if c_ph_line_break%ISOPEN then
1438: CLOSE c_ph_line_break;
1439: end if;
1440:
1441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1442:
1443: END;
1444:
1445:

Line 1786: x_msg_data := Fnd_Msg_Pub.Get( p_msg_index => Fnd_Msg_Pub.G_FIRST, p_encoded => FND_API.G_FALSE );

1782:
1783: END LOOP;
1784: x_recs_copied := l_cnt-1;
1785: x_msg_count := Fnd_Msg_Pub.Count_Msg;
1786: x_msg_data := Fnd_Msg_Pub.Get( p_msg_index => Fnd_Msg_Pub.G_FIRST, p_encoded => FND_API.G_FALSE );
1787: IF x_msg_count>0 THEN x_return_status := OKC_API.G_RET_STS_ERROR; END IF;
1788: EXCEPTION
1789: WHEN OTHERS THEN
1790: -- store SQL error message on message stack for caller

Line 1794: x_msg_data := Fnd_Msg_Pub.Get( p_msg_index => Fnd_Msg_Pub.G_FIRST, p_encoded => FND_API.G_FALSE );

1790: -- store SQL error message on message stack for caller
1791: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
1792: -- notify caller of an UNEXPECTED error
1793: x_msg_count := Fnd_Msg_Pub.Count_Msg;
1794: x_msg_data := Fnd_Msg_Pub.Get( p_msg_index => Fnd_Msg_Pub.G_FIRST, p_encoded => FND_API.G_FALSE );
1795: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1796: END COPY_LINES;
1797:
1798: END OKC_PHI_PVT;