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.

[Home] [Help]

APPS.AHL_VWP_PROJ_PROD_PVT dependencies on AHL_PRD_WORKORDER_PVT

Line 5516: p_x_relationship_tbl IN OUT NOCOPY AHL_PRD_WORKORDER_PVT.prd_workorder_rel_tbl

5512: PROCEDURE Get_Task_Relationships
5513: ( p_visit_id IN NUMBER,
5514: p_visit_number IN NUMBER,
5515: p_visit_task_id IN NUMBER,
5516: p_x_relationship_tbl IN OUT NOCOPY AHL_PRD_WORKORDER_PVT.prd_workorder_rel_tbl
5517: ) IS
5518:
5519: CURSOR get_mwo_wip_entity_id(x_visit_id IN NUMBER) IS
5520: SELECT wip_entity_id

Line 5657: p_x_relationship_tbl IN OUT NOCOPY AHL_PRD_WORKORDER_PVT.prd_workorder_rel_tbl

5653: PROCEDURE Get_Visit_Relationships
5654: (
5655: p_visit_id IN NUMBER,
5656: p_visit_number IN NUMBER,
5657: p_x_relationship_tbl IN OUT NOCOPY AHL_PRD_WORKORDER_PVT.prd_workorder_rel_tbl
5658: )
5659: AS
5660: L_API_VERSION CONSTANT NUMBER := 1.0;
5661: L_API_NAME CONSTANT VARCHAR2(30) := 'Get_Visit_Relationships';

Line 5905: p_x_relationship_tbl IN OUT NOCOPY AHL_PRD_WORKORDER_PVT.prd_workorder_rel_tbl

5901: (
5902: p_visit_number IN NUMBER,
5903: p_visit_task_id IN NUMBER,
5904: p_visit_task_number IN NUMBER,
5905: p_x_relationship_tbl IN OUT NOCOPY AHL_PRD_WORKORDER_PVT.prd_workorder_rel_tbl
5906: )
5907: AS
5908: L_API_VERSION CONSTANT NUMBER := 1.0;
5909: L_API_NAME CONSTANT VARCHAR2(30) := 'Get_Task_Dependencies';

Line 6003: p_x_relationship_tbl IN OUT NOCOPY AHL_PRD_WORKORDER_PVT.prd_workorder_rel_tbl

5999: PROCEDURE Get_Visit_Dependencies
6000: (
6001: p_visit_id IN NUMBER,
6002: p_visit_number IN NUMBER,
6003: p_x_relationship_tbl IN OUT NOCOPY AHL_PRD_WORKORDER_PVT.prd_workorder_rel_tbl
6004: )
6005: AS
6006: L_API_VERSION CONSTANT NUMBER := 1.0;
6007: L_API_NAME CONSTANT VARCHAR2(30) := 'Get_Visit_Dependencies';

Line 6082: l_prd_workorder_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_TBL;

6078: IS
6079: L_API_VERSION CONSTANT NUMBER := 1.0;
6080: L_API_NAME CONSTANT VARCHAR2(30) := 'Push_to_Production';
6081: L_DEBUG_KEY CONSTANT VARCHAR2(100):= 'ahl.plsql.' || G_PKG_NAME || '.' || L_API_NAME;
6082: l_prd_workorder_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_TBL;
6083: /* Begin Changes by Shkalyan */
6084: l_prd_workorder_rel_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REL_TBL;
6085: l_firm_planned_flag VARCHAR2(1) := FND_PROFILE.value('AHL_PRD_FIRM_PLANNED_FLAG');
6086: l_visit_wo_id NUMBER;

Line 6084: l_prd_workorder_rel_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REL_TBL;

6080: L_API_NAME CONSTANT VARCHAR2(30) := 'Push_to_Production';
6081: L_DEBUG_KEY CONSTANT VARCHAR2(100):= 'ahl.plsql.' || G_PKG_NAME || '.' || L_API_NAME;
6082: l_prd_workorder_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_TBL;
6083: /* Begin Changes by Shkalyan */
6084: l_prd_workorder_rel_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REL_TBL;
6085: l_firm_planned_flag VARCHAR2(1) := FND_PROFILE.value('AHL_PRD_FIRM_PLANNED_FLAG');
6086: l_visit_wo_id NUMBER;
6087: l_visit_wo_ovn NUMBER;
6088: l_visit_wo_status VARCHAR2(30);

Line 6739: 'Before calling AHL_PRD_WORKORDER_PVT.reschedule_visit_jobs');

6735:
6736: IF (l_log_statement >= l_log_current_level) THEN
6737: fnd_log.string(l_log_statement,
6738: L_DEBUG_KEY,
6739: 'Before calling AHL_PRD_WORKORDER_PVT.reschedule_visit_jobs');
6740: END IF;
6741:
6742: AHL_PRD_WORKORDER_PVT.reschedule_visit_jobs(
6743: P_API_VERSION => 1.0,

Line 6742: AHL_PRD_WORKORDER_PVT.reschedule_visit_jobs(

6738: L_DEBUG_KEY,
6739: 'Before calling AHL_PRD_WORKORDER_PVT.reschedule_visit_jobs');
6740: END IF;
6741:
6742: AHL_PRD_WORKORDER_PVT.reschedule_visit_jobs(
6743: P_API_VERSION => 1.0,
6744: x_return_status => l_return_status,
6745: x_msg_count => l_msg_count,
6746: x_msg_data => l_msg_data,

Line 6754: 'After calling AHL_PRD_WORKORDER_PVT.reschedule_visit_jobs. Return Status = ' || l_return_status);

6750:
6751: IF (l_log_statement >= l_log_current_level) THEN
6752: fnd_log.string(l_log_statement,
6753: L_DEBUG_KEY,
6754: 'After calling AHL_PRD_WORKORDER_PVT.reschedule_visit_jobs. Return Status = ' || l_return_status);
6755: END IF;
6756:
6757: IF (l_return_status <> Fnd_Api.G_RET_STS_SUCCESS) THEN
6758: IF (l_log_statement >= l_log_current_level) THEN

Line 6761: 'Errors from AHL_PRD_WORKORDER_PVT.reschedule_visit_jobs. Message count: ' ||

6757: IF (l_return_status <> Fnd_Api.G_RET_STS_SUCCESS) THEN
6758: IF (l_log_statement >= l_log_current_level) THEN
6759: fnd_log.string(l_log_statement,
6760: L_DEBUG_KEY,
6761: 'Errors from AHL_PRD_WORKORDER_PVT.reschedule_visit_jobs. Message count: ' ||
6762: l_msg_count || ', message data: ' || l_msg_data);
6763: END IF;
6764: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
6765: RAISE FND_API.G_EXC_ERROR;

Line 6777: -- AHL_PRD_WORKORDER_PVT.RESCHEDULE_VISIT_JOBS API.

6773: -- If p_module_type is 'CST' then master workorder status should stay as DRAFT
6774: -- Update only workorder time
6775:
6776: -- Re-Query the OVN for the workorder again since its been updated by
6777: -- AHL_PRD_WORKORDER_PVT.RESCHEDULE_VISIT_JOBS API.
6778: -- Balaji added this fix as a part of BAE OVN bug fix for workorders.
6779: OPEN c_visit_job (p_visit_id);
6780: FETCH c_visit_job INTO l_visit_wo_id, l_visit_wo_ovn, l_visit_wo_status, l_visit_wo_start_time,l_visit_wo_end_time;
6781: CLOSE c_visit_job;

Line 7299: 'Before calling AHL_PRD_WORKORDER_PVT.Process_Jobs. l_prd_workorder_tbl.COUNT = ' || l_prd_workorder_tbl.COUNT);

7295:
7296: IF (l_log_statement >= l_log_current_level) THEN
7297: fnd_log.string(l_log_statement,
7298: L_DEBUG_KEY,
7299: 'Before calling AHL_PRD_WORKORDER_PVT.Process_Jobs. l_prd_workorder_tbl.COUNT = ' || l_prd_workorder_tbl.COUNT);
7300: END IF;
7301:
7302: AHL_PRD_WORKORDER_PVT.Process_Jobs
7303: ( p_api_version => p_api_version,

Line 7302: AHL_PRD_WORKORDER_PVT.Process_Jobs

7298: L_DEBUG_KEY,
7299: 'Before calling AHL_PRD_WORKORDER_PVT.Process_Jobs. l_prd_workorder_tbl.COUNT = ' || l_prd_workorder_tbl.COUNT);
7300: END IF;
7301:
7302: AHL_PRD_WORKORDER_PVT.Process_Jobs
7303: ( p_api_version => p_api_version,
7304: p_init_msg_list => p_init_msg_list,
7305: p_commit => FND_API.G_FALSE,
7306: p_validation_level => p_validation_level,

Line 7320: 'After calling AHL_PRD_WORKORDER_PVT.Process_Jobs. Return Status = ' || l_return_status);

7316:
7317: IF (l_log_statement >= l_log_current_level) THEN
7318: fnd_log.string(l_log_statement,
7319: L_DEBUG_KEY,
7320: 'After calling AHL_PRD_WORKORDER_PVT.Process_Jobs. Return Status = ' || l_return_status);
7321: END IF;
7322:
7323: IF (l_return_status <> Fnd_Api.G_RET_STS_SUCCESS) THEN
7324: IF (l_log_statement >= l_log_current_level) THEN

Line 7327: 'Errors from AHL_PRD_WORKORDER_PVT.Process_Jobs. Message count: ' ||

7323: IF (l_return_status <> Fnd_Api.G_RET_STS_SUCCESS) THEN
7324: IF (l_log_statement >= l_log_current_level) THEN
7325: fnd_log.string(l_log_statement,
7326: L_DEBUG_KEY,
7327: 'Errors from AHL_PRD_WORKORDER_PVT.Process_Jobs. Message count: ' ||
7328: l_msg_count || ', message data: ' || l_msg_data);
7329: END IF;
7330: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
7331: RAISE FND_API.G_EXC_ERROR;

Line 7443: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Before calling AHL_PRD_WORKORDER_PVT.cancel_visit_jobs l_workorder_id= '||l_workorder_id);

7439: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
7440: WHERE STAGE_ID = l_task_to_cancel_rec.stage_id;
7441: END IF;
7442: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
7443: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Before calling AHL_PRD_WORKORDER_PVT.cancel_visit_jobs l_workorder_id= '||l_workorder_id);
7444: END IF;
7445: END IF;
7446:
7447: AHL_PRD_WORKORDER_PVT.cancel_visit_jobs

Line 7447: AHL_PRD_WORKORDER_PVT.cancel_visit_jobs

7443: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Before calling AHL_PRD_WORKORDER_PVT.cancel_visit_jobs l_workorder_id= '||l_workorder_id);
7444: END IF;
7445: END IF;
7446:
7447: AHL_PRD_WORKORDER_PVT.cancel_visit_jobs
7448: (p_api_version => 1.0,
7449: p_init_msg_list => FND_API.G_FALSE,
7450: p_commit => FND_API.G_FALSE,
7451: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 7462: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'After calling AHL_PRD_WORKORDER_PVT.cancel_visit_jobs - l_return_status : '||l_return_status);

7458: p_unit_effectivity_id => NULL,
7459: p_workorder_id => l_task_to_cancel_rec.workorder_id);
7460:
7461: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
7462: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'After calling AHL_PRD_WORKORDER_PVT.cancel_visit_jobs - l_return_status : '||l_return_status);
7463: END IF;
7464:
7465: IF NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
7466: x_msg_count := l_msg_count;

Line 8370: -- SKPATHAK:: Moved this API call from after AHL_PRD_WORKORDER_PVT.Process_Jobs call to before AHL_PRD_WORKORDER_PVT.Process_Jobs call

8366: END IF;
8367: END IF; -- l_return_status <> FND_API.G_RET_STS_SUCCESS
8368:
8369: -- SKPATHAK :: ER:12730539 :: 01-AUG-2011 :: START :: Validate Return to Supply Flags of only the released tasks
8370: -- SKPATHAK:: Moved this API call from after AHL_PRD_WORKORDER_PVT.Process_Jobs call to before AHL_PRD_WORKORDER_PVT.Process_Jobs call
8371: FOR i IN l_tasks_tbl.FIRST..l_tasks_tbl.LAST LOOP
8372: l_val_task_tbl(i) := l_tasks_tbl(i);
8373: END LOOP;
8374:

Line 9450: l_prd_workorder_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_TBL;

9446: L_DEBUG_KEY CONSTANT VARCHAR2(100) := 'ahl.plsql.' || G_PKG_NAME || '.' || L_API_NAME;
9447: l_msg_data VARCHAR2(2000);
9448: l_return_status VARCHAR2(1);
9449: l_msg_count NUMBER;
9450: l_prd_workorder_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_TBL;
9451: idx NUMBER := 0;
9452: l_prd_workorder_rel_tbl AHL_PRD_WORKORDER_PVT.prd_workorder_rel_tbl;
9453: l_manual_summ_task_flag VARCHAR2(1) ;
9454: l_task_cnt NUMBER := 0;

Line 9452: l_prd_workorder_rel_tbl AHL_PRD_WORKORDER_PVT.prd_workorder_rel_tbl;

9448: l_return_status VARCHAR2(1);
9449: l_msg_count NUMBER;
9450: l_prd_workorder_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_TBL;
9451: idx NUMBER := 0;
9452: l_prd_workorder_rel_tbl AHL_PRD_WORKORDER_PVT.prd_workorder_rel_tbl;
9453: l_manual_summ_task_flag VARCHAR2(1) ;
9454: l_task_cnt NUMBER := 0;
9455: l_firm_planned_flag VARCHAR2(1) := FND_PROFILE.value('AHL_PRD_FIRM_PLANNED_FLAG');
9456: l_planned_order_flag VARCHAR2(1); --added by skpathak for VWPE

Line 9992: AHL_PRD_WORKORDER_PVT.Process_Jobs

9988: 'Before calling PROCESS_JOBS for visit_id: ' || p_visit_id);
9989: END IF;
9990:
9991: -- Call Production API to create work orders
9992: AHL_PRD_WORKORDER_PVT.Process_Jobs
9993: (p_api_version => l_api_version ,
9994: p_init_msg_list => p_init_msg_list,
9995: p_commit => 'F',
9996: p_validation_level => p_validation_level,

Line 10086: AHL_PRD_WORKORDER_PVT.cancel_visit_jobs

10082: LAST_UPDATE_DATE = SYSDATE,
10083: LAST_UPDATED_BY = Fnd_Global.USER_ID,
10084: LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
10085: WHERE visit_task_id = p_tasks_tbl(i).visit_task_id;
10086: AHL_PRD_WORKORDER_PVT.cancel_visit_jobs
10087: (p_api_version => 1.0,
10088: p_init_msg_list => FND_API.G_TRUE,
10089: p_commit => FND_API.G_FALSE,
10090: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 10782: p_x_relationship_tbl IN OUT NOCOPY AHL_PRD_WORKORDER_PVT.prd_workorder_rel_tbl

10778: p_visit_id IN NUMBER,
10779: p_visit_number IN NUMBER,
10780: p_unit_effectivity_id IN NUMBER,
10781: p_module_type IN VARCHAR2 := Null, /*NR-MR Changes - sowsubra*/
10782: p_x_relationship_tbl IN OUT NOCOPY AHL_PRD_WORKORDER_PVT.prd_workorder_rel_tbl
10783: )
10784: AS
10785:
10786: -- Get all the Task Dependencies for the given MR.

Line 10869: p_x_relationship_tbl IN OUT NOCOPY AHL_PRD_WORKORDER_PVT.prd_workorder_rel_tbl

10865: p_visit_id IN NUMBER,
10866: p_visit_number IN NUMBER,
10867: p_unit_effectivity_id IN NUMBER,
10868: p_module_type IN VARCHAR2 := Null, /*NR-MR Changes - sowsubra*/
10869: p_x_relationship_tbl IN OUT NOCOPY AHL_PRD_WORKORDER_PVT.prd_workorder_rel_tbl
10870: )
10871: AS
10872: -- Get all the MR tasks associated to the given UE.
10873: /*NR-MR Changes - sowsubra - modified the cursor to fetch the sr_id, mr_id and task type*/

Line 11125: l_prd_workorder_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_TBL;

11121: IS
11122: L_API_VERSION CONSTANT NUMBER := 1.0;
11123: L_API_NAME CONSTANT VARCHAR2(30) := 'Push_MR_to_Production';
11124: L_DEBUG_KEY CONSTANT VARCHAR2(100) := 'ahl.plsql.' || G_PKG_NAME || '.' || L_API_NAME;
11125: l_prd_workorder_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_TBL;
11126: l_prd_workorder_rel_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REL_TBL;
11127: --commented by tchimira to honor the firm_planned_flag entered by the user for the ER 9368251
11128: -- VWPE - tchimira.Uncommented the below to put the passed firm_planned_flag in local variable
11129: -- which may be over written based on visit firmed_flag or past_dated_flag

Line 11126: l_prd_workorder_rel_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REL_TBL;

11122: L_API_VERSION CONSTANT NUMBER := 1.0;
11123: L_API_NAME CONSTANT VARCHAR2(30) := 'Push_MR_to_Production';
11124: L_DEBUG_KEY CONSTANT VARCHAR2(100) := 'ahl.plsql.' || G_PKG_NAME || '.' || L_API_NAME;
11125: l_prd_workorder_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_TBL;
11126: l_prd_workorder_rel_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REL_TBL;
11127: --commented by tchimira to honor the firm_planned_flag entered by the user for the ER 9368251
11128: -- VWPE - tchimira.Uncommented the below to put the passed firm_planned_flag in local variable
11129: -- which may be over written based on visit firmed_flag or past_dated_flag
11130: l_firm_planned_flag VARCHAR2(1) := p_firm_planned_flag;

Line 11576: fnd_log.string(l_log_statement,L_DEBUG_KEY,'Before calling AHL_PRD_WORKORDER_PVT.Process_Jobs ');

11572: );*/
11573:
11574: IF (l_log_statement >= l_log_current_level) THEN
11575: --fnd_log.string(l_log_statement,L_DEBUG_KEY,'After Getting MR Dependencies ');
11576: fnd_log.string(l_log_statement,L_DEBUG_KEY,'Before calling AHL_PRD_WORKORDER_PVT.Process_Jobs ');
11577: END IF;
11578:
11579: AHL_PRD_WORKORDER_PVT.Process_Jobs
11580: (

Line 11579: AHL_PRD_WORKORDER_PVT.Process_Jobs

11575: --fnd_log.string(l_log_statement,L_DEBUG_KEY,'After Getting MR Dependencies ');
11576: fnd_log.string(l_log_statement,L_DEBUG_KEY,'Before calling AHL_PRD_WORKORDER_PVT.Process_Jobs ');
11577: END IF;
11578:
11579: AHL_PRD_WORKORDER_PVT.Process_Jobs
11580: (
11581: p_api_version => p_api_version,
11582: p_init_msg_list => p_init_msg_list,
11583: p_commit => FND_API.G_FALSE,

Line 11595: fnd_log.string(l_log_statement,L_DEBUG_KEY,'After calling AHL_PRD_WORKORDER_PVT.Process_Jobs - l_return_status : '||l_return_status);

11591: p_prd_workorder_rel_tbl=> l_prd_workorder_rel_tbl
11592: );
11593:
11594: IF (l_log_statement >= l_log_current_level) THEN
11595: fnd_log.string(l_log_statement,L_DEBUG_KEY,'After calling AHL_PRD_WORKORDER_PVT.Process_Jobs - l_return_status : '||l_return_status);
11596: END IF;
11597:
11598: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
11599: IF (l_log_statement >= l_log_current_level) THEN

Line 12623: -- p_prd_workorder_tbl IN AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_TBL Required

12619: -- Standard IN Parameters :
12620: -- p_commit IN VARCHAR2 Fnd_Api.G_FALSE
12621: --
12622: -- Update_Project_Task_Times Parameters
12623: -- p_prd_workorder_tbl IN AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_TBL Required
12624: --
12625: -- Standard OUT Parameters :
12626: -- x_return_status OUT VARCHAR2 Required
12627: -- x_msg_count OUT NUMBER Required

Line 12634: ( p_prd_workorder_tbl IN AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_TBL,

12630: -- Version :
12631: -- 04 January, 2007 Bug#5758813 SOWSUBRA Initial Version - 1.0
12632: -------------------------------------------------------------------
12633: PROCEDURE Update_Project_Task_Times
12634: ( p_prd_workorder_tbl IN AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_TBL,
12635: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
12636: x_return_status OUT NOCOPY VARCHAR2,
12637: x_msg_count OUT NOCOPY NUMBER,
12638: x_msg_data OUT NOCOPY VARCHAR2

Line 13024: l_prd_workorder_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_TBL;

13020: y_return_status VARCHAR2(1);
13021: l_flag VARCHAR2(1);
13022: l_status_flag VARCHAR2(1);
13023: l_msg_data VARCHAR2(2000);
13024: l_prd_workorder_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_TBL;
13025: /* Begin Changes by Shkalyan */
13026: l_prd_workorder_rel_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REL_TBL;
13027: l_firm_planned_flag VARCHAR2(1) := FND_PROFILE.value('AHL_PRD_FIRM_PLANNED_FLAG');
13028: l_visit_wo_id NUMBER;

Line 13026: l_prd_workorder_rel_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REL_TBL;

13022: l_status_flag VARCHAR2(1);
13023: l_msg_data VARCHAR2(2000);
13024: l_prd_workorder_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_TBL;
13025: /* Begin Changes by Shkalyan */
13026: l_prd_workorder_rel_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REL_TBL;
13027: l_firm_planned_flag VARCHAR2(1) := FND_PROFILE.value('AHL_PRD_FIRM_PLANNED_FLAG');
13028: l_visit_wo_id NUMBER;
13029: l_visit_wo_ovn NUMBER;
13030: /* End Changes by Shkalyan */

Line 13398: fnd_log.string(l_log_statement,L_DEBUG_KEY,'Before calling AHL_PRD_WORKORDER_PVT.Process_Jobs');

13394: END IF;
13395:
13396: IF l_prd_workorder_tbl.COUNT > 0 THEN
13397: IF (l_log_statement >= l_log_current_level) THEN
13398: fnd_log.string(l_log_statement,L_DEBUG_KEY,'Before calling AHL_PRD_WORKORDER_PVT.Process_Jobs');
13399: END IF;
13400:
13401: /* Begin Changes by Shkalyan */
13402: AHL_PRD_WORKORDER_PVT.Process_Jobs

Line 13402: AHL_PRD_WORKORDER_PVT.Process_Jobs

13398: fnd_log.string(l_log_statement,L_DEBUG_KEY,'Before calling AHL_PRD_WORKORDER_PVT.Process_Jobs');
13399: END IF;
13400:
13401: /* Begin Changes by Shkalyan */
13402: AHL_PRD_WORKORDER_PVT.Process_Jobs
13403: (p_api_version => p_api_version,
13404: p_init_msg_list => p_init_msg_list,
13405: p_commit => Fnd_Api.g_false,
13406: p_validation_level => p_validation_level,

Line 13417: fnd_log.string(l_log_statement,L_DEBUG_KEY,'After calling AHL_PRD_WORKORDER_PVT.Process_Jobs - x_return_status = '||x_return_status);

13413: p_prd_workorder_rel_tbl => l_prd_workorder_rel_tbl
13414: );
13415: /* End Changes by Shkalyan */
13416: IF (l_log_statement >= l_log_current_level) THEN
13417: fnd_log.string(l_log_statement,L_DEBUG_KEY,'After calling AHL_PRD_WORKORDER_PVT.Process_Jobs - x_return_status = '||x_return_status);
13418: END IF;
13419:
13420: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
13421: RAISE Fnd_Api.G_EXC_ERROR;

Line 14665: l_prd_workorder_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_TBL;

14661: L_DEBUG_KEY CONSTANT VARCHAR2(100) := 'ahl.plsql.' || G_PKG_NAME || '.' || L_API_NAME;
14662: l_msg_data VARCHAR2(2000);
14663: l_return_status VARCHAR2(1);
14664: l_msg_count NUMBER;
14665: l_prd_workorder_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_TBL;
14666: idx NUMBER := 0;
14667: l_prd_workorder_rel_tbl AHL_PRD_WORKORDER_PVT.prd_workorder_rel_tbl;
14668: l_manual_summ_task_flag VARCHAR2(1) ;
14669: l_firm_planned_flag VARCHAR2(1) := FND_PROFILE.value('AHL_PRD_FIRM_PLANNED_FLAG');

Line 14667: l_prd_workorder_rel_tbl AHL_PRD_WORKORDER_PVT.prd_workorder_rel_tbl;

14663: l_return_status VARCHAR2(1);
14664: l_msg_count NUMBER;
14665: l_prd_workorder_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_TBL;
14666: idx NUMBER := 0;
14667: l_prd_workorder_rel_tbl AHL_PRD_WORKORDER_PVT.prd_workorder_rel_tbl;
14668: l_manual_summ_task_flag VARCHAR2(1) ;
14669: l_firm_planned_flag VARCHAR2(1) := FND_PROFILE.value('AHL_PRD_FIRM_PLANNED_FLAG');
14670: l_workorder_id NUMBER;
14671: --SKPATHAK :: VWPE: ER:12424063 :: 26-MAY-2011

Line 14769: -- SKPATHAK:: Moved this API call from after AHL_PRD_WORKORDER_PVT.Process_Jobs call to before AHL_PRD_WORKORDER_PVT.Process_Jobs call

14765: END IF; -- Return Status is not Success
14766: -- SKPATHAK :: VWPE: ER:12424063 :: 26-MAY-2011 :: ENDS
14767:
14768: -- SKPATHAK :: ER:12730539 :: 01-AUG-2011 :: START :: Validate Return to Supply Flags
14769: -- SKPATHAK:: Moved this API call from after AHL_PRD_WORKORDER_PVT.Process_Jobs call to before AHL_PRD_WORKORDER_PVT.Process_Jobs call
14770: FOR i IN l_task_tbl_in.FIRST..l_task_tbl_in.LAST LOOP
14771: l_val_task_tbl(i) := l_task_tbl_in(i);
14772: END LOOP;
14773:

Line 15127: AHL_PRD_WORKORDER_PVT.Process_Jobs

15123: ||' ,l_prd_workorder_tbl.count: ' || l_prd_workorder_tbl.count || ' ,l_prd_workorder_rel_tbl.count: ' || l_prd_workorder_rel_tbl.count);
15124: END IF;
15125:
15126: -- Call Production API to create work orders
15127: AHL_PRD_WORKORDER_PVT.Process_Jobs
15128: (p_api_version => l_api_version ,
15129: p_init_msg_list => FND_API.G_FALSE,
15130: p_commit => FND_API.G_FALSE,
15131: p_validation_level => p_validation_level,

Line 15229: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Before calling AHL_PRD_WORKORDER_PVT.cancel_visit_jobs l_workorder_id= '||l_workorder_id);

15225: FETCH get_task_wo INTO l_workorder_id;
15226: CLOSE get_task_wo;
15227:
15228: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
15229: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Before calling AHL_PRD_WORKORDER_PVT.cancel_visit_jobs l_workorder_id= '||l_workorder_id);
15230: END IF;
15231:
15232: AHL_PRD_WORKORDER_PVT.cancel_visit_jobs
15233: (p_api_version => 1.0,

Line 15232: AHL_PRD_WORKORDER_PVT.cancel_visit_jobs

15228: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
15229: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'Before calling AHL_PRD_WORKORDER_PVT.cancel_visit_jobs l_workorder_id= '||l_workorder_id);
15230: END IF;
15231:
15232: AHL_PRD_WORKORDER_PVT.cancel_visit_jobs
15233: (p_api_version => 1.0,
15234: p_init_msg_list => FND_API.G_FALSE,
15235: p_commit => FND_API.G_FALSE,
15236: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 15247: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'After calling AHL_PRD_WORKORDER_PVT.cancel_visit_jobs - l_return_status : '||l_return_status);

15243: p_unit_effectivity_id => NULL,
15244: p_workorder_id => l_workorder_id);
15245:
15246: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
15247: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,'After calling AHL_PRD_WORKORDER_PVT.cancel_visit_jobs - l_return_status : '||l_return_status);
15248: END IF;
15249:
15250: IF l_return_status <> 'S' THEN
15251: RAISE Fnd_Api.G_EXC_ERROR;