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.AHL_VWP_PROJ_PROD_PVT dependencies on PA_PROJECT_PUB

Line 614: 'Before calling PA_PROJECT_PUB.CHECK_UNIQUE_TASK_NUMBER.');

610: -- change end
611: IF (l_log_statement >= l_log_current_level) THEN
612: fnd_log.string(l_log_statement,
613: L_DEBUG_KEY,
614: 'Before calling PA_PROJECT_PUB.CHECK_UNIQUE_TASK_NUMBER.');
615: fnd_log.string(l_log_statement,
616: L_DEBUG_KEY,
617: 'p_project_id = ' || c_visit_rec.project_id);
618: fnd_log.string(l_log_statement,

Line 626: PA_PROJECT_PUB.Check_Unique_Task_Number

622: L_DEBUG_KEY,
623: 'p_task_number = ' || c_task_rec.visit_task_number);
624: END IF;
625:
626: PA_PROJECT_PUB.Check_Unique_Task_Number
627: ( p_api_version_number => 1,
628: p_init_msg_list => l_init_msg_list,
629: p_return_status => l_return_status,
630: p_msg_count => l_msg_count,

Line 641: 'After calling PA_PROJECT_PUB.check_unique_task_number. p_unique_task_number_flag = ' ||

637:
638: IF (l_log_statement >= l_log_current_level) THEN
639: fnd_log.string(l_log_statement,
640: L_DEBUG_KEY,
641: 'After calling PA_PROJECT_PUB.check_unique_task_number. p_unique_task_number_flag = ' ||
642: l_project_tsk_flag || ' Return Status = ' || l_return_status);
643: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
644: fnd_log.string(l_log_statement,
645: L_DEBUG_KEY,

Line 646: 'Errors from PA_PROJECT_PUB.check_unique_task_number. Message count: ' ||

642: l_project_tsk_flag || ' Return Status = ' || l_return_status);
643: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
644: fnd_log.string(l_log_statement,
645: L_DEBUG_KEY,
646: 'Errors from PA_PROJECT_PUB.check_unique_task_number. Message count: ' ||
647: l_msg_count || ', message data: ' || l_msg_data);
648: END IF;
649: fnd_log.string(l_log_statement,
650: L_DEBUG_KEY,

Line 651: 'Before calling PA_PROJECT_PUB.check_unique_task_reference.');

647: l_msg_count || ', message data: ' || l_msg_data);
648: END IF;
649: fnd_log.string(l_log_statement,
650: L_DEBUG_KEY,
651: 'Before calling PA_PROJECT_PUB.check_unique_task_reference.');
652: END IF;
653:
654: PA_PROJECT_PUB.Check_Unique_Task_Reference
655: (p_api_version_number => 1,

Line 654: PA_PROJECT_PUB.Check_Unique_Task_Reference

650: L_DEBUG_KEY,
651: 'Before calling PA_PROJECT_PUB.check_unique_task_reference.');
652: END IF;
653:
654: PA_PROJECT_PUB.Check_Unique_Task_Reference
655: (p_api_version_number => 1,
656: p_init_msg_list => l_init_msg_list,
657: p_return_status => l_return_status,
658: p_msg_count => l_msg_count,

Line 674: 'Errors from PA_PROJECT_PUB.check_unique_task_number. Message count: ' ||

670: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
671: IF (l_log_statement >= l_log_current_level) THEN
672: fnd_log.string(l_log_statement,
673: L_DEBUG_KEY,
674: 'Errors from PA_PROJECT_PUB.check_unique_task_number. Message count: ' ||
675: l_msg_count || ', message data: ' || l_msg_data);
676: END IF;
677: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
678: RAISE FND_API.G_EXC_ERROR;

Line 686: fnd_log.string(l_log_statement,L_DEBUG_KEY,'Before calling PA_PROJECT_PUB.ADD_TASK..');

682: END IF;
683:
684: IF l_project_tsk_flag = 'Y' AND l_proj_ref_flag = 'Y' THEN
685: IF (l_log_statement >= l_log_current_level) THEN
686: fnd_log.string(l_log_statement,L_DEBUG_KEY,'Before calling PA_PROJECT_PUB.ADD_TASK..');
687: fnd_log.string(l_log_statement,L_DEBUG_KEY,'c_task_rec.PROJECT_ID=: ' || c_task_rec.PROJECT_ID);
688: fnd_log.string(l_log_statement,L_DEBUG_KEY,'c_task_rec.VISIT_NUMBER=: ' || c_task_rec.VISIT_NUMBER);
689: fnd_log.string(l_log_statement,L_DEBUG_KEY,'c_task_rec.VISIT_TASK_NUMBER=: ' || c_task_rec.VISIT_TASK_NUMBER);
690: fnd_log.string(l_log_statement,L_DEBUG_KEY,'c_task_rec.VISIT_TASK_NAME=: ' || c_task_rec.VISIT_TASK_NAME);

Line 694: PA_PROJECT_PUB.ADD_TASK

690: fnd_log.string(l_log_statement,L_DEBUG_KEY,'c_task_rec.VISIT_TASK_NAME=: ' || c_task_rec.VISIT_TASK_NAME);
691: fnd_log.string(l_log_statement,L_DEBUG_KEY,'c_task_rec.DESCRIPTION=: ' || c_task_rec.DESCRIPTION);
692: END IF;
693:
694: PA_PROJECT_PUB.ADD_TASK
695: (p_api_version_number => 1
696: ,p_commit => l_commit
697: ,p_init_msg_list => l_init_msg_list
698: ,p_msg_count => l_msg_count

Line 721: fnd_log.string(l_log_statement,L_DEBUG_KEY,'After calling PA_PROJECT_PUB.ADD_TASK - l_return_status = '||l_return_status);

717: ,p_task_id => l_task_id
718: );
719:
720: IF (l_log_statement >= l_log_current_level) THEN
721: fnd_log.string(l_log_statement,L_DEBUG_KEY,'After calling PA_PROJECT_PUB.ADD_TASK - l_return_status = '||l_return_status);
722: END IF;
723:
724: IF (l_return_status <> 'S') THEN
725: IF (fnd_msg_pub.count_msg > 0 ) THEN

Line 917: fnd_log.string(l_log_statement,L_DEBUG_KEY,'Before calling PA_PROJECT_PUB.CHECK_DELETE_TASK_OK');

913: END IF;
914:
915: IF l_chk_project = 'Y' THEN
916: IF (l_log_statement >= l_log_current_level) THEN
917: fnd_log.string(l_log_statement,L_DEBUG_KEY,'Before calling PA_PROJECT_PUB.CHECK_DELETE_TASK_OK');
918: fnd_log.string(l_log_statement,L_DEBUG_KEY,'c_visit_rec.PROJECT_ID - '|| c_visit_rec.PROJECT_ID);
919: fnd_log.string(l_log_statement,L_DEBUG_KEY,'c_visit_rec.visit_number - '|| c_visit_rec.visit_number);
920: fnd_log.string(l_log_statement,L_DEBUG_KEY,'c_task_rec.PROJECT_TASK_ID - '|| c_task_rec.PROJECT_TASK_ID);
921: fnd_log.string(l_log_statement,L_DEBUG_KEY,'c_task_rec.VISIT_TASK_NUMBER - '|| c_task_rec.VISIT_TASK_NUMBER);

Line 925: PA_PROJECT_PUB.CHECK_DELETE_TASK_OK

921: fnd_log.string(l_log_statement,L_DEBUG_KEY,'c_task_rec.VISIT_TASK_NUMBER - '|| c_task_rec.VISIT_TASK_NUMBER);
922: fnd_log.string(l_log_statement,L_DEBUG_KEY,'l_del_task_flag - '|| l_del_task_flag);
923: END IF;
924:
925: PA_PROJECT_PUB.CHECK_DELETE_TASK_OK
926: ( p_api_version_number => 1
927: , p_init_msg_list => l_init_msg_list
928: , p_return_status => l_return_status
929: , p_msg_count => l_msg_count

Line 941: 'After calling PA_PROJECT_PUB.check_delete_task_ok. Return Status = ' ||

937:
938: IF (l_log_statement >= l_log_current_level) THEN
939: fnd_log.string(l_log_statement,
940: L_DEBUG_KEY,
941: 'After calling PA_PROJECT_PUB.check_delete_task_ok. Return Status = ' ||
942: l_return_status || ', delete task flag = ' || l_del_task_flag);
943: END IF;
944:
945: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 949: 'Errors from PA_PROJECT_PUB.check_delete_task_ok. Message count: ' ||

945: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
946: IF (l_log_statement >= l_log_current_level) THEN
947: fnd_log.string(l_log_statement,
948: L_DEBUG_KEY,
949: 'Errors from PA_PROJECT_PUB.check_delete_task_ok. Message count: ' ||
950: l_msg_count || ', message data: ' || l_msg_data);
951: END IF;
952: x_return_status := l_return_status;
953: RAISE FND_API.G_EXC_ERROR;

Line 959: 'Before calling PA_PROJECT_PUB.delete_task.');

955: IF l_del_task_flag = 'Y' THEN
956: IF (l_log_statement >= l_log_current_level) THEN
957: fnd_log.string(l_log_statement,
958: L_DEBUG_KEY,
959: 'Before calling PA_PROJECT_PUB.delete_task.');
960: END IF;
961:
962: PA_PROJECT_PUB.DELETE_TASK
963: ( p_api_version_number => 1

Line 962: PA_PROJECT_PUB.DELETE_TASK

958: L_DEBUG_KEY,
959: 'Before calling PA_PROJECT_PUB.delete_task.');
960: END IF;
961:
962: PA_PROJECT_PUB.DELETE_TASK
963: ( p_api_version_number => 1
964: ,p_commit => l_commit
965: ,p_init_msg_list => l_init_msg_list
966: ,p_msg_count => l_msg_count

Line 982: 'After calling PA_PROJECT_PUB.delete_task. Return Status = ' ||

978:
979: IF (l_log_statement >= l_log_current_level) THEN
980: fnd_log.string(l_log_statement,
981: L_DEBUG_KEY,
982: 'After calling PA_PROJECT_PUB.delete_task. Return Status = ' ||
983: l_return_status);
984: END IF;
985:
986: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 990: 'Errors from PA_PROJECT_PUB.delete_task. Message count: ' ||

986: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
987: IF (l_log_statement >= l_log_current_level) THEN
988: fnd_log.string(l_log_statement,
989: L_DEBUG_KEY,
990: 'Errors from PA_PROJECT_PUB.delete_task. Message count: ' ||
991: l_msg_count || ', message data: ' || l_msg_data);
992: END IF;
993: x_return_status := Fnd_Api.g_ret_sts_error;
994: RAISE FND_API.G_EXC_ERROR;

Line 1043: l_project_rec PA_PROJECT_PUB.PROJECT_IN_REC_TYPE;

1039: l_msg_data VARCHAR2(2000);
1040: G_EXC_ERROR EXCEPTION;
1041:
1042: -- Define local table and record datatypes
1043: l_project_rec PA_PROJECT_PUB.PROJECT_IN_REC_TYPE;
1044: l_project_out PA_PROJECT_PUB.PROJECT_OUT_REC_TYPE;
1045: l_task_in PA_PROJECT_PUB.TASK_IN_TBL_TYPE;
1046: l_task_out PA_PROJECT_PUB.TASK_OUT_TBL_TYPE;
1047: l_key_members PA_PROJECT_PUB.PROJECT_ROLE_TBL_TYPE;

Line 1044: l_project_out PA_PROJECT_PUB.PROJECT_OUT_REC_TYPE;

1040: G_EXC_ERROR EXCEPTION;
1041:
1042: -- Define local table and record datatypes
1043: l_project_rec PA_PROJECT_PUB.PROJECT_IN_REC_TYPE;
1044: l_project_out PA_PROJECT_PUB.PROJECT_OUT_REC_TYPE;
1045: l_task_in PA_PROJECT_PUB.TASK_IN_TBL_TYPE;
1046: l_task_out PA_PROJECT_PUB.TASK_OUT_TBL_TYPE;
1047: l_key_members PA_PROJECT_PUB.PROJECT_ROLE_TBL_TYPE;
1048: l_class_categories PA_PROJECT_PUB.CLASS_CATEGORY_TBL_TYPE;

Line 1045: l_task_in PA_PROJECT_PUB.TASK_IN_TBL_TYPE;

1041:
1042: -- Define local table and record datatypes
1043: l_project_rec PA_PROJECT_PUB.PROJECT_IN_REC_TYPE;
1044: l_project_out PA_PROJECT_PUB.PROJECT_OUT_REC_TYPE;
1045: l_task_in PA_PROJECT_PUB.TASK_IN_TBL_TYPE;
1046: l_task_out PA_PROJECT_PUB.TASK_OUT_TBL_TYPE;
1047: l_key_members PA_PROJECT_PUB.PROJECT_ROLE_TBL_TYPE;
1048: l_class_categories PA_PROJECT_PUB.CLASS_CATEGORY_TBL_TYPE;
1049: -- Post 11.5.10

Line 1046: l_task_out PA_PROJECT_PUB.TASK_OUT_TBL_TYPE;

1042: -- Define local table and record datatypes
1043: l_project_rec PA_PROJECT_PUB.PROJECT_IN_REC_TYPE;
1044: l_project_out PA_PROJECT_PUB.PROJECT_OUT_REC_TYPE;
1045: l_task_in PA_PROJECT_PUB.TASK_IN_TBL_TYPE;
1046: l_task_out PA_PROJECT_PUB.TASK_OUT_TBL_TYPE;
1047: l_key_members PA_PROJECT_PUB.PROJECT_ROLE_TBL_TYPE;
1048: l_class_categories PA_PROJECT_PUB.CLASS_CATEGORY_TBL_TYPE;
1049: -- Post 11.5.10
1050: -- RROY

Line 1047: l_key_members PA_PROJECT_PUB.PROJECT_ROLE_TBL_TYPE;

1043: l_project_rec PA_PROJECT_PUB.PROJECT_IN_REC_TYPE;
1044: l_project_out PA_PROJECT_PUB.PROJECT_OUT_REC_TYPE;
1045: l_task_in PA_PROJECT_PUB.TASK_IN_TBL_TYPE;
1046: l_task_out PA_PROJECT_PUB.TASK_OUT_TBL_TYPE;
1047: l_key_members PA_PROJECT_PUB.PROJECT_ROLE_TBL_TYPE;
1048: l_class_categories PA_PROJECT_PUB.CLASS_CATEGORY_TBL_TYPE;
1049: -- Post 11.5.10
1050: -- RROY
1051: l_param_data PJM_PROJECT_PARAM_PUB.ParamRecType;

Line 1048: l_class_categories PA_PROJECT_PUB.CLASS_CATEGORY_TBL_TYPE;

1044: l_project_out PA_PROJECT_PUB.PROJECT_OUT_REC_TYPE;
1045: l_task_in PA_PROJECT_PUB.TASK_IN_TBL_TYPE;
1046: l_task_out PA_PROJECT_PUB.TASK_OUT_TBL_TYPE;
1047: l_key_members PA_PROJECT_PUB.PROJECT_ROLE_TBL_TYPE;
1048: l_class_categories PA_PROJECT_PUB.CLASS_CATEGORY_TBL_TYPE;
1049: -- Post 11.5.10
1050: -- RROY
1051: l_param_data PJM_PROJECT_PARAM_PUB.ParamRecType;
1052: -- yazhou 26Sept2005 starts

Line 1328: 'Before calling PA_PROJECT_PUB.check_unique_project_reference to check for ' || l_project_num_prefix || c_visit_rec.visit_number);

1324: IF l_chk_project = 'Y' THEN
1325: IF (l_log_statement >= l_log_current_level) THEN
1326: fnd_log.string(l_log_statement,
1327: L_DEBUG_KEY,
1328: 'Before calling PA_PROJECT_PUB.check_unique_project_reference to check for ' || l_project_num_prefix || c_visit_rec.visit_number);
1329: END IF;
1330:
1331: PA_PROJECT_PUB.Check_Unique_Project_Reference(
1332: p_api_version_number => 1,

Line 1331: PA_PROJECT_PUB.Check_Unique_Project_Reference(

1327: L_DEBUG_KEY,
1328: 'Before calling PA_PROJECT_PUB.check_unique_project_reference to check for ' || l_project_num_prefix || c_visit_rec.visit_number);
1329: END IF;
1330:
1331: PA_PROJECT_PUB.Check_Unique_Project_Reference(
1332: p_api_version_number => 1,
1333: p_init_msg_list => l_init_msg_list,
1334: p_return_status => l_return_status,
1335: p_msg_count => l_msg_count,

Line 1345: 'Returned from PA_PROJECT_PUB.check_unique_project_reference: p_unique_project_ref_flag = ' || l_project_flag || ', Return Status = ' || l_return_status );

1341:
1342: IF (l_log_statement >= l_log_current_level) THEN
1343: fnd_log.string(l_log_statement,
1344: L_DEBUG_KEY,
1345: 'Returned from PA_PROJECT_PUB.check_unique_project_reference: p_unique_project_ref_flag = ' || l_project_flag || ', Return Status = ' || l_return_status );
1346: END IF;
1347:
1348: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1349: IF (l_log_statement >= l_log_current_level) THEN

Line 1352: 'Errors from PA_PROJECT_PUB.check_unique_project_reference. Message count: ' ||

1348: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1349: IF (l_log_statement >= l_log_current_level) THEN
1350: fnd_log.string(l_log_statement,
1351: L_DEBUG_KEY,
1352: 'Errors from PA_PROJECT_PUB.check_unique_project_reference. Message count: ' ||
1353: l_msg_count || ', message data: ' || l_msg_data);
1354: END IF;
1355: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1356: RAISE FND_API.G_EXC_ERROR;

Line 1366: 'Before calling PA_PROJECT_PUB.create_project');

1362: IF l_project_flag = 'Y' THEN
1363: IF (l_log_statement >= l_log_current_level) THEN
1364: fnd_log.string(l_log_statement,
1365: L_DEBUG_KEY,
1366: 'Before calling PA_PROJECT_PUB.create_project');
1367: END IF;
1368:
1369: PA_PROJECT_PUB.CREATE_PROJECT
1370: (p_api_version_number => 1,

Line 1369: PA_PROJECT_PUB.CREATE_PROJECT

1365: L_DEBUG_KEY,
1366: 'Before calling PA_PROJECT_PUB.create_project');
1367: END IF;
1368:
1369: PA_PROJECT_PUB.CREATE_PROJECT
1370: (p_api_version_number => 1,
1371: p_commit => l_commit,
1372: p_init_msg_list => l_init_msg_list,
1373: p_msg_count => l_msg_count,

Line 1389: 'After calling PA_PROJECT_PUB.create_project. Project_Id = ' ||

1385:
1386: IF (l_log_statement >= l_log_current_level) THEN
1387: fnd_log.string(l_log_statement,
1388: L_DEBUG_KEY,
1389: 'After calling PA_PROJECT_PUB.create_project. Project_Id = ' ||
1390: l_project_out.pa_project_id || ' Return Status = ' || x_return_status);
1391: END IF;
1392:
1393: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 1397: 'Errors from PA_PROJECT_PUB.create_project. Message count: ' ||

1393: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1394: IF (l_log_statement >= l_log_current_level) THEN
1395: fnd_log.string(l_log_statement,
1396: L_DEBUG_KEY,
1397: 'Errors from PA_PROJECT_PUB.create_project. Message count: ' ||
1398: l_msg_count || ', message data: ' || l_msg_data);
1399: END IF;
1400: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1401: RAISE FND_API.G_EXC_ERROR;

Line 1559: l_project_rec PA_PROJECT_PUB.PROJECT_IN_REC_TYPE;

1555: l_msg_data VARCHAR2(2000);
1556: G_EXC_ERROR EXCEPTION;
1557:
1558: -- Define local table and record datatypes
1559: l_project_rec PA_PROJECT_PUB.PROJECT_IN_REC_TYPE;
1560: l_project_out PA_PROJECT_PUB.PROJECT_OUT_REC_TYPE;
1561: l_param_data PJM_PROJECT_PARAM_PUB.ParamRecType;
1562: l_task_in PA_PROJECT_PUB.TASK_IN_TBL_TYPE;
1563: l_task_out PA_PROJECT_PUB.TASK_OUT_TBL_TYPE;

Line 1560: l_project_out PA_PROJECT_PUB.PROJECT_OUT_REC_TYPE;

1556: G_EXC_ERROR EXCEPTION;
1557:
1558: -- Define local table and record datatypes
1559: l_project_rec PA_PROJECT_PUB.PROJECT_IN_REC_TYPE;
1560: l_project_out PA_PROJECT_PUB.PROJECT_OUT_REC_TYPE;
1561: l_param_data PJM_PROJECT_PARAM_PUB.ParamRecType;
1562: l_task_in PA_PROJECT_PUB.TASK_IN_TBL_TYPE;
1563: l_task_out PA_PROJECT_PUB.TASK_OUT_TBL_TYPE;
1564: l_key_members PA_PROJECT_PUB.PROJECT_ROLE_TBL_TYPE;

Line 1562: l_task_in PA_PROJECT_PUB.TASK_IN_TBL_TYPE;

1558: -- Define local table and record datatypes
1559: l_project_rec PA_PROJECT_PUB.PROJECT_IN_REC_TYPE;
1560: l_project_out PA_PROJECT_PUB.PROJECT_OUT_REC_TYPE;
1561: l_param_data PJM_PROJECT_PARAM_PUB.ParamRecType;
1562: l_task_in PA_PROJECT_PUB.TASK_IN_TBL_TYPE;
1563: l_task_out PA_PROJECT_PUB.TASK_OUT_TBL_TYPE;
1564: l_key_members PA_PROJECT_PUB.PROJECT_ROLE_TBL_TYPE;
1565: l_class_categories PA_PROJECT_PUB.CLASS_CATEGORY_TBL_TYPE;
1566:

Line 1563: l_task_out PA_PROJECT_PUB.TASK_OUT_TBL_TYPE;

1559: l_project_rec PA_PROJECT_PUB.PROJECT_IN_REC_TYPE;
1560: l_project_out PA_PROJECT_PUB.PROJECT_OUT_REC_TYPE;
1561: l_param_data PJM_PROJECT_PARAM_PUB.ParamRecType;
1562: l_task_in PA_PROJECT_PUB.TASK_IN_TBL_TYPE;
1563: l_task_out PA_PROJECT_PUB.TASK_OUT_TBL_TYPE;
1564: l_key_members PA_PROJECT_PUB.PROJECT_ROLE_TBL_TYPE;
1565: l_class_categories PA_PROJECT_PUB.CLASS_CATEGORY_TBL_TYPE;
1566:
1567: -- yazhou 26Sept2005 starts

Line 1564: l_key_members PA_PROJECT_PUB.PROJECT_ROLE_TBL_TYPE;

1560: l_project_out PA_PROJECT_PUB.PROJECT_OUT_REC_TYPE;
1561: l_param_data PJM_PROJECT_PARAM_PUB.ParamRecType;
1562: l_task_in PA_PROJECT_PUB.TASK_IN_TBL_TYPE;
1563: l_task_out PA_PROJECT_PUB.TASK_OUT_TBL_TYPE;
1564: l_key_members PA_PROJECT_PUB.PROJECT_ROLE_TBL_TYPE;
1565: l_class_categories PA_PROJECT_PUB.CLASS_CATEGORY_TBL_TYPE;
1566:
1567: -- yazhou 26Sept2005 starts
1568: -- ER#4618348

Line 1565: l_class_categories PA_PROJECT_PUB.CLASS_CATEGORY_TBL_TYPE;

1561: l_param_data PJM_PROJECT_PARAM_PUB.ParamRecType;
1562: l_task_in PA_PROJECT_PUB.TASK_IN_TBL_TYPE;
1563: l_task_out PA_PROJECT_PUB.TASK_OUT_TBL_TYPE;
1564: l_key_members PA_PROJECT_PUB.PROJECT_ROLE_TBL_TYPE;
1565: l_class_categories PA_PROJECT_PUB.CLASS_CATEGORY_TBL_TYPE;
1566:
1567: -- yazhou 26Sept2005 starts
1568: -- ER#4618348
1569: -- l_project_name_prefix VARCHAR2(10);

Line 1845: fnd_log.string(l_log_statement,L_DEBUG_KEY,'Before calling PA_PROJECT_PUB.UPDATE_PROJECT');

1841: -- Need to update proejct for
1842: IF c_visit_rec.PROJECT_ID IS NOT NULL THEN
1843: IF (l_log_statement >= l_log_current_level) THEN
1844: fnd_log.string(l_log_statement,L_DEBUG_KEY,'Visit Project ID = ' || c_visit_rec.PROJECT_ID);
1845: fnd_log.string(l_log_statement,L_DEBUG_KEY,'Before calling PA_PROJECT_PUB.UPDATE_PROJECT');
1846: END IF;
1847:
1848: PA_PROJECT_PUB.UPDATE_PROJECT
1849: (p_api_version_number => 1,

Line 1848: PA_PROJECT_PUB.UPDATE_PROJECT

1844: fnd_log.string(l_log_statement,L_DEBUG_KEY,'Visit Project ID = ' || c_visit_rec.PROJECT_ID);
1845: fnd_log.string(l_log_statement,L_DEBUG_KEY,'Before calling PA_PROJECT_PUB.UPDATE_PROJECT');
1846: END IF;
1847:
1848: PA_PROJECT_PUB.UPDATE_PROJECT
1849: (p_api_version_number => 1,
1850: p_commit => l_commit,
1851: p_init_msg_list => l_init_msg_list,
1852: p_msg_count => l_msg_count,

Line 1866: fnd_log.string(l_log_statement,L_DEBUG_KEY,'After calling PA_PROJECT_PUB.UPDATE_PROJECT - l_return_status = '||l_return_status);

1862: p_tasks_out => l_task_out
1863: );
1864:
1865: IF (l_log_statement >= l_log_current_level) THEN
1866: fnd_log.string(l_log_statement,L_DEBUG_KEY,'After calling PA_PROJECT_PUB.UPDATE_PROJECT - l_return_status = '||l_return_status);
1867: END IF;
1868:
1869: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1870: IF (l_log_statement >= l_log_current_level) THEN

Line 1871: fnd_log.string(l_log_statement,L_DEBUG_KEY,'Errors from PA_PROJECT_PUB.UPDATE_PROJECT - l_msg_count = '||l_msg_count);

1867: END IF;
1868:
1869: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1870: IF (l_log_statement >= l_log_current_level) THEN
1871: fnd_log.string(l_log_statement,L_DEBUG_KEY,'Errors from PA_PROJECT_PUB.UPDATE_PROJECT - l_msg_count = '||l_msg_count);
1872: END IF;
1873: RAISE Fnd_Api.g_exc_error;
1874: END IF;
1875:

Line 2096: fnd_log.string(l_log_statement,L_DEBUG_KEY,'Before calling : PA_PROJECT_PUB.CHECK_DELETE_PROJECT_OK');

2092: Fnd_Msg_Pub.ADD;
2093: RAISE Fnd_Api.G_EXC_ERROR;
2094: ELSE
2095: IF (l_log_statement >= l_log_current_level) THEN
2096: fnd_log.string(l_log_statement,L_DEBUG_KEY,'Before calling : PA_PROJECT_PUB.CHECK_DELETE_PROJECT_OK');
2097: END IF;
2098:
2099: PA_PROJECT_PUB.CHECK_DELETE_PROJECT_OK
2100: ( p_api_version_number => 1

Line 2099: PA_PROJECT_PUB.CHECK_DELETE_PROJECT_OK

2095: IF (l_log_statement >= l_log_current_level) THEN
2096: fnd_log.string(l_log_statement,L_DEBUG_KEY,'Before calling : PA_PROJECT_PUB.CHECK_DELETE_PROJECT_OK');
2097: END IF;
2098:
2099: PA_PROJECT_PUB.CHECK_DELETE_PROJECT_OK
2100: ( p_api_version_number => 1
2101: , p_init_msg_list => l_init_msg_list
2102: , p_return_status => l_return_status
2103: , p_msg_count => l_msg_count

Line 2111: fnd_log.string(l_log_statement,L_DEBUG_KEY,'After calling PA_PROJECT_PUB.CHECK_DELETE_PROJECT_OK - l_return_status = '||l_return_status);

2107: , p_delete_project_ok_flag => l_del_proj_flag
2108: );
2109:
2110: IF (l_log_statement >= l_log_current_level) THEN
2111: fnd_log.string(l_log_statement,L_DEBUG_KEY,'After calling PA_PROJECT_PUB.CHECK_DELETE_PROJECT_OK - l_return_status = '||l_return_status);
2112: END IF;
2113:
2114: IF l_return_status <> 'S' THEN
2115: RAISE G_EXC_ERROR;

Line 2124: fnd_log.string(l_log_statement,L_DEBUG_KEY,'Before calling PA_PROJECT_PUB.DELETE_PROJECT');

2120: END IF;
2121:
2122: IF l_del_proj_flag = 'Y' THEN
2123: IF (l_log_statement >= l_log_current_level) THEN
2124: fnd_log.string(l_log_statement,L_DEBUG_KEY,'Before calling PA_PROJECT_PUB.DELETE_PROJECT');
2125: END IF;
2126:
2127: PA_PROJECT_PUB.DELETE_PROJECT
2128: ( p_api_version_number => 1

Line 2127: PA_PROJECT_PUB.DELETE_PROJECT

2123: IF (l_log_statement >= l_log_current_level) THEN
2124: fnd_log.string(l_log_statement,L_DEBUG_KEY,'Before calling PA_PROJECT_PUB.DELETE_PROJECT');
2125: END IF;
2126:
2127: PA_PROJECT_PUB.DELETE_PROJECT
2128: ( p_api_version_number => 1
2129: ,p_commit => l_commit
2130: ,p_init_msg_list => l_init_msg_list
2131: ,p_msg_count => l_msg_count

Line 2140: fnd_log.string(l_log_statement,L_DEBUG_KEY,'After calling PA_PROJECT_PUB.DELETE_PROJECT - l_return_status = '||l_return_status);

2136: ,p_pa_project_id => c_visit_rec.PROJECT_ID
2137: );
2138:
2139: IF (l_log_statement >= l_log_current_level) THEN
2140: fnd_log.string(l_log_statement,L_DEBUG_KEY,'After calling PA_PROJECT_PUB.DELETE_PROJECT - l_return_status = '||l_return_status);
2141: END IF;
2142:
2143: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2144: IF (l_log_statement >= l_log_current_level) THEN

Line 2145: fnd_log.string(l_log_statement,L_DEBUG_KEY,'Errors from PA_PROJECT_PUB.DELETE_PROJECT API : '|| x_msg_count );

2141: END IF;
2142:
2143: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2144: IF (l_log_statement >= l_log_current_level) THEN
2145: fnd_log.string(l_log_statement,L_DEBUG_KEY,'Errors from PA_PROJECT_PUB.DELETE_PROJECT API : '|| x_msg_count );
2146: END IF;
2147: RAISE Fnd_Api.g_exc_error;
2148: END IF;
2149: END IF;

Line 8310: fnd_log.string(l_log_statement,L_DEBUG_KEY,'Before calling PA_PROJECT_PUB.Check_Unique_Task_Number');

8306: WHILE c_task%FOUND
8307: LOOP
8308: IF ((c_task_rec.PROJECT_TASK_ID IS NULL) AND (l_curr_task_id <> c_task_rec.visit_task_id))THEN
8309: IF (l_log_statement >= l_log_current_level) THEN
8310: fnd_log.string(l_log_statement,L_DEBUG_KEY,'Before calling PA_PROJECT_PUB.Check_Unique_Task_Number');
8311: END IF;
8312:
8313: PA_PROJECT_PUB.Check_Unique_Task_Number
8314: ( p_api_version_number => 1,

Line 8313: PA_PROJECT_PUB.Check_Unique_Task_Number

8309: IF (l_log_statement >= l_log_current_level) THEN
8310: fnd_log.string(l_log_statement,L_DEBUG_KEY,'Before calling PA_PROJECT_PUB.Check_Unique_Task_Number');
8311: END IF;
8312:
8313: PA_PROJECT_PUB.Check_Unique_Task_Number
8314: ( p_api_version_number => 1,
8315: p_init_msg_list => l_init_msg_list,
8316: p_return_status => l_return_status,
8317: p_msg_count => l_msg_count,

Line 8326: fnd_log.string(l_log_statement,L_DEBUG_KEY,'After calling PA_PROJECT_PUB.Check_Unique_Task_Number - l_project_tsk_flag : '|| l_project_tsk_flag);

8322: p_unique_task_number_flag => l_project_tsk_flag
8323: ) ;
8324:
8325: IF (l_log_statement >= l_log_current_level) THEN
8326: fnd_log.string(l_log_statement,L_DEBUG_KEY,'After calling PA_PROJECT_PUB.Check_Unique_Task_Number - l_project_tsk_flag : '|| l_project_tsk_flag);
8327: fnd_log.string(l_log_statement,L_DEBUG_KEY,'Before calling PA_PROJECT_PUB.Check_Unique_Task_Reference');
8328: END IF;
8329:
8330: PA_PROJECT_PUB.Check_Unique_Task_Reference

Line 8327: fnd_log.string(l_log_statement,L_DEBUG_KEY,'Before calling PA_PROJECT_PUB.Check_Unique_Task_Reference');

8323: ) ;
8324:
8325: IF (l_log_statement >= l_log_current_level) THEN
8326: fnd_log.string(l_log_statement,L_DEBUG_KEY,'After calling PA_PROJECT_PUB.Check_Unique_Task_Number - l_project_tsk_flag : '|| l_project_tsk_flag);
8327: fnd_log.string(l_log_statement,L_DEBUG_KEY,'Before calling PA_PROJECT_PUB.Check_Unique_Task_Reference');
8328: END IF;
8329:
8330: PA_PROJECT_PUB.Check_Unique_Task_Reference
8331: ( p_api_version_number => 1,

Line 8330: PA_PROJECT_PUB.Check_Unique_Task_Reference

8326: fnd_log.string(l_log_statement,L_DEBUG_KEY,'After calling PA_PROJECT_PUB.Check_Unique_Task_Number - l_project_tsk_flag : '|| l_project_tsk_flag);
8327: fnd_log.string(l_log_statement,L_DEBUG_KEY,'Before calling PA_PROJECT_PUB.Check_Unique_Task_Reference');
8328: END IF;
8329:
8330: PA_PROJECT_PUB.Check_Unique_Task_Reference
8331: ( p_api_version_number => 1,
8332: p_init_msg_list => l_init_msg_list,
8333: p_return_status => l_return_status,
8334: p_msg_count => l_msg_count,

Line 8343: fnd_log.string(l_log_statement,L_DEBUG_KEY,'After calling PA_PROJECT_PUB.Check_Unique_Task_Reference - l_proj_ref_flag = ' || l_proj_ref_flag);

8339: p_unique_task_ref_flag => l_proj_ref_flag
8340: );
8341:
8342: IF (l_log_statement >= l_log_current_level) THEN
8343: fnd_log.string(l_log_statement,L_DEBUG_KEY,'After calling PA_PROJECT_PUB.Check_Unique_Task_Reference - l_proj_ref_flag = ' || l_proj_ref_flag);
8344: END IF;
8345:
8346: IF l_project_tsk_flag = 'Y' AND l_proj_ref_flag = 'Y' THEN
8347: IF (l_log_statement >= l_log_current_level) THEN

Line 8348: fnd_log.string(l_log_statement,L_DEBUG_KEY,'Before calling PA_PROJECT_PUB.ADD_TASK');

8344: END IF;
8345:
8346: IF l_project_tsk_flag = 'Y' AND l_proj_ref_flag = 'Y' THEN
8347: IF (l_log_statement >= l_log_current_level) THEN
8348: fnd_log.string(l_log_statement,L_DEBUG_KEY,'Before calling PA_PROJECT_PUB.ADD_TASK');
8349: fnd_log.string(l_log_statement,L_DEBUG_KEY,'c_task_rec.PROJECT_ID=:' || c_visit_rec.PROJECT_ID);
8350: fnd_log.string(l_log_statement,L_DEBUG_KEY,'c_task_rec.VISIT_NUMBER=:' || c_visit_rec.VISIT_NUMBER);
8351: fnd_log.string(l_log_statement,L_DEBUG_KEY,'c_task_rec.VISIT_TASK_NUMBER=:' || c_task_rec.VISIT_TASK_NUMBER);
8352: fnd_log.string(l_log_statement,L_DEBUG_KEY,'c_task_rec.VISIT_TASK_NAME=:' || c_task_rec.VISIT_TASK_NAME);

Line 8361: PA_PROJECT_PUB.ADD_TASK

8357: OPEN get_prj_task_dtls_cur(c_task_rec.visit_task_id);
8358: FETCH get_prj_task_dtls_cur INTO l_get_prj_task_dtls_cur_rec;
8359: CLOSE get_prj_task_dtls_cur;
8360:
8361: PA_PROJECT_PUB.ADD_TASK
8362: (p_api_version_number => 1
8363: ,p_commit => l_commit
8364: ,p_init_msg_list => l_init_msg_list
8365: ,p_msg_count => l_msg_count

Line 8391: fnd_log.string(l_log_statement,L_DEBUG_KEY,'After calling PA_PROJECT_PUB.ADD_TASK - l_return_status : '||l_return_status);

8387: ,p_task_id => l_task_id
8388: );
8389:
8390: IF (l_log_statement >= l_log_current_level) THEN
8391: fnd_log.string(l_log_statement,L_DEBUG_KEY,'After calling PA_PROJECT_PUB.ADD_TASK - l_return_status : '||l_return_status);
8392: END IF;
8393:
8394: IF (l_return_status <> 'S') THEN
8395: IF (fnd_msg_pub.count_msg > 0 ) THEN

Line 8845: l_task_in_tbl PA_PROJECT_PUB.TASK_IN_TBL_TYPE;

8841: x_msg_data OUT NOCOPY VARCHAR2
8842: )
8843: AS
8844:
8845: l_task_in_tbl PA_PROJECT_PUB.TASK_IN_TBL_TYPE;
8846: task_index NUMBER;
8847: idx NUMBER;
8848: l_project_rec PA_PROJECT_PUB.PROJECT_IN_REC_TYPE;
8849: L_API_NAME CONSTANT VARCHAR2(30) := 'Update_Project_Task_Times';

Line 8848: l_project_rec PA_PROJECT_PUB.PROJECT_IN_REC_TYPE;

8844:
8845: l_task_in_tbl PA_PROJECT_PUB.TASK_IN_TBL_TYPE;
8846: task_index NUMBER;
8847: idx NUMBER;
8848: l_project_rec PA_PROJECT_PUB.PROJECT_IN_REC_TYPE;
8849: L_API_NAME CONSTANT VARCHAR2(30) := 'Update_Project_Task_Times';
8850: L_DEBUG_KEY CONSTANT VARCHAR2(100) := 'ahl.plsql.' || G_PKG_NAME || '.' || L_API_NAME;
8851: l_msg_count NUMBER;
8852: l_msg_data VARCHAR2(2000);

Line 8854: l_task_out PA_PROJECT_PUB.TASK_OUT_TBL_TYPE;

8850: L_DEBUG_KEY CONSTANT VARCHAR2(100) := 'ahl.plsql.' || G_PKG_NAME || '.' || L_API_NAME;
8851: l_msg_count NUMBER;
8852: l_msg_data VARCHAR2(2000);
8853: l_return_status VARCHAR2(1);
8854: l_task_out PA_PROJECT_PUB.TASK_OUT_TBL_TYPE;
8855: l_workflow_started VARCHAR2(1);
8856: l_key_members PA_PROJECT_PUB.PROJECT_ROLE_TBL_TYPE;
8857: l_class_categories PA_PROJECT_PUB.CLASS_CATEGORY_TBL_TYPE;
8858: l_project_out PA_PROJECT_PUB.PROJECT_OUT_REC_TYPE;

Line 8856: l_key_members PA_PROJECT_PUB.PROJECT_ROLE_TBL_TYPE;

8852: l_msg_data VARCHAR2(2000);
8853: l_return_status VARCHAR2(1);
8854: l_task_out PA_PROJECT_PUB.TASK_OUT_TBL_TYPE;
8855: l_workflow_started VARCHAR2(1);
8856: l_key_members PA_PROJECT_PUB.PROJECT_ROLE_TBL_TYPE;
8857: l_class_categories PA_PROJECT_PUB.CLASS_CATEGORY_TBL_TYPE;
8858: l_project_out PA_PROJECT_PUB.PROJECT_OUT_REC_TYPE;
8859:
8860:

Line 8857: l_class_categories PA_PROJECT_PUB.CLASS_CATEGORY_TBL_TYPE;

8853: l_return_status VARCHAR2(1);
8854: l_task_out PA_PROJECT_PUB.TASK_OUT_TBL_TYPE;
8855: l_workflow_started VARCHAR2(1);
8856: l_key_members PA_PROJECT_PUB.PROJECT_ROLE_TBL_TYPE;
8857: l_class_categories PA_PROJECT_PUB.CLASS_CATEGORY_TBL_TYPE;
8858: l_project_out PA_PROJECT_PUB.PROJECT_OUT_REC_TYPE;
8859:
8860:
8861: --fetches the schedule start and completion date of workorder

Line 8858: l_project_out PA_PROJECT_PUB.PROJECT_OUT_REC_TYPE;

8854: l_task_out PA_PROJECT_PUB.TASK_OUT_TBL_TYPE;
8855: l_workflow_started VARCHAR2(1);
8856: l_key_members PA_PROJECT_PUB.PROJECT_ROLE_TBL_TYPE;
8857: l_class_categories PA_PROJECT_PUB.CLASS_CATEGORY_TBL_TYPE;
8858: l_project_out PA_PROJECT_PUB.PROJECT_OUT_REC_TYPE;
8859:
8860:
8861: --fetches the schedule start and completion date of workorder
8862: CURSOR get_wo_schedule_dates_cur(p_wo_id IN NUMBER) IS

Line 8969: 'Before calling PA_PROJECT_PUB.update_project');

8965: --rnahata End
8966: IF (l_log_statement >= l_log_current_level) THEN
8967: fnd_log.string(l_log_statement,
8968: L_DEBUG_KEY,
8969: 'Before calling PA_PROJECT_PUB.update_project');
8970: END IF;
8971:
8972: --Now call update_project api to update the values in projects table
8973: PA_PROJECT_PUB.UPDATE_PROJECT(

Line 8973: PA_PROJECT_PUB.UPDATE_PROJECT(

8969: 'Before calling PA_PROJECT_PUB.update_project');
8970: END IF;
8971:
8972: --Now call update_project api to update the values in projects table
8973: PA_PROJECT_PUB.UPDATE_PROJECT(
8974: p_api_version_number => 1,
8975: p_commit => p_commit,
8976: p_msg_count => l_msg_count,
8977: p_msg_data => l_msg_data,

Line 8991: 'After calling PA_PROJECT_PUB.update_project. Return Status = ' || l_return_status);

8987:
8988: IF (l_log_statement >= l_log_current_level) THEN
8989: fnd_log.string(l_log_statement,
8990: L_DEBUG_KEY,
8991: 'After calling PA_PROJECT_PUB.update_project. Return Status = ' || l_return_status);
8992: END IF;
8993:
8994: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
8995: IF (l_log_statement >= l_log_current_level) THEN

Line 8998: 'Errors from PA_PROJECT_PUB.update_project. Message count: ' ||

8994: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
8995: IF (l_log_statement >= l_log_current_level) THEN
8996: fnd_log.string(l_log_statement,
8997: L_DEBUG_KEY,
8998: 'Errors from PA_PROJECT_PUB.update_project. Message count: ' ||
8999: l_msg_count || ', message data: ' || l_msg_data);
9000: END IF;
9001: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
9002: RAISE FND_API.G_EXC_ERROR;