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_PRD_RESOURCE_TRANX_PVT dependencies on FND_API

Line 179: p_prd_resrc_txn_tbl(I).workorder_id=FND_API.G_MISS_NUM

175: THEN
176: FOR i in p_prd_resrc_txn_tbl.FIRST..p_prd_resrc_txn_tbl.LAST
177: LOOP
178: IF p_prd_resrc_txn_tbl(I).workorder_id IS NULL OR
179: p_prd_resrc_txn_tbl(I).workorder_id=FND_API.G_MISS_NUM
180: THEN
181: FND_MESSAGE.set_name('AHL','AHL_PRD_WORKORDER_ID_NULL');
182: FND_MSG_PUB.ADD;
183: ELSE

Line 187: or p_prd_resrc_txn_tbl(I).organization_id=fnd_api.G_miss_num

183: ELSE
184:
185: /* sracha: already queried this info in translate_meaning_to_id procedure.
186: If p_prd_resrc_txn_tbl(I).organization_id is null
187: or p_prd_resrc_txn_tbl(I).organization_id=fnd_api.G_miss_num
188: Then
189: OPEN get_wo_org_id(p_prd_resrc_txn_tbl(I).workorder_id);
190: FETCH get_wo_org_id INTO l_org_id;
191: CLOSE get_wo_org_id;

Line 236: IF l_return_status = FND_API.G_TRUE THEN

232: p_workorder_id => p_prd_resrc_txn_tbl(i).workorder_id,
233: p_ue_id => NULL,
234: p_visit_id => NULL,
235: p_item_instance_id => NULL);
236: IF l_return_status = FND_API.G_TRUE THEN
237: FND_MESSAGE.Set_Name('AHL', 'AHL_PP_RESTXN_UNTLCKD');
238: FND_MESSAGE.Set_Token('WO_NAME', l_wrkrec.workorder_name);
239: FND_MSG_PUB.ADD;
240: IF G_DEBUG='Y' THEN

Line 270: OR p_prd_resrc_txn_tbl(I).workorder_operation_id=FND_API.G_MISS_NUM

266: AHL_DEBUG_PUB.debug( 'After Work Order ID validation:status is:' || l_wrkrec.STATUS_CODE,l_proc_name);
267: END IF;
268:
269: IF p_prd_resrc_txn_tbl(I).workorder_operation_id IS NULL
270: OR p_prd_resrc_txn_tbl(I).workorder_operation_id=FND_API.G_MISS_NUM
271: THEN
272: FND_MESSAGE.set_name('AHL','AHL_PRD_WORKORDER_OP_ID_NULL');
273: FND_MSG_PUB.ADD;
274: END IF;

Line 278: or p_prd_resrc_txn_tbl(I).operation_sequence_num=fnd_api.g_miss_num

274: END IF;
275:
276: -- validate operation sequence.
277: If p_prd_resrc_txn_tbl(I).operation_sequence_num is null
278: or p_prd_resrc_txn_tbl(I).operation_sequence_num=fnd_api.g_miss_num
279: Then
280: FND_MESSAGE.set_name('AHL','AHL_PRD_OPSEQNUM_NULL');
281: FND_MSG_PUB.ADD;
282: Else

Line 299: and p_prd_resrc_txn_tbl(I).resource_sequence_num<>fnd_api.g_miss_num

295: End if; -- p_prd_resrc_txn_tbl(I).operation_sequence_num is null
296:
297: -- Validate resource sequence.
298: If p_prd_resrc_txn_tbl(I).resource_sequence_num is not null
299: and p_prd_resrc_txn_tbl(I).resource_sequence_num<>fnd_api.g_miss_num
300: Then
301: --Select count(*) into l_ctr
302: Select 1 into l_ctr
303: From AHL_OPERATION_RESOURCES A

Line 317: p_prd_resrc_txn_tbl(I).department_id=fnd_api.g_miss_num

313: End if;
314:
315: -- validate department id.
316: If p_prd_resrc_txn_tbl(I).department_id is null or
317: p_prd_resrc_txn_tbl(I).department_id=fnd_api.g_miss_num
318: Then
319: FND_MESSAGE.set_name('AHL','AHL_PRD_TRX_DEPTID_NULL');
320: FND_MESSAGE.SET_TOKEN('OPER_RES',P_prd_resrc_txn_tbl(I).OPERATION_SEQUENCE_NUM||'-'
321: ||p_prd_resrc_txn_tbl(I).RESOURCE_SEQUENCE_NUM);

Line 389: If (p_prd_resrc_txn_tbl(I).qty is null OR p_prd_resrc_txn_tbl(I).qty = fnd_api.g_miss_num)

385:
386: -- rroy
387: -- R12 Tech UIs
388: -- throw an error if both qty and end date are null
389: If (p_prd_resrc_txn_tbl(I).qty is null OR p_prd_resrc_txn_tbl(I).qty = fnd_api.g_miss_num)
390: AND (p_prd_resrc_txn_tbl(I).end_date IS NULL OR p_prd_resrc_txn_tbl(I).transaction_date IS NULL)
391: THEN
392: FND_MESSAGE.set_name('AHL','AHL_PRD_TRX_QTY_NULL');
393: -- Change the message to reflect that at least one of qty or end date should be given

Line 505: p_prd_resrc_txn_tbl(i).serial_number<>FND_API.G_MISS_CHAR

501:
502: -- validate serial number.
503: -- Adithya modified the code to take department_id for Bug # 6326254 - Start
504: IF p_prd_resrc_txn_tbl(i).serial_number IS NOT NULL AND
505: p_prd_resrc_txn_tbl(i).serial_number<>FND_API.G_MISS_CHAR
506: THEN
507:
508: Open get_instance_sernum (p_prd_resrc_txn_tbl(i).department_id,
509: p_prd_resrc_txn_tbl(i).serial_number,

Line 546: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

542: AHL_DEBUG_PUB.debug( 'End of procedure',l_proc_name);
543: END IF;
544:
545: --Adithya added the following debug
546: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
547: p_count => l_msg_count,
548: p_data => l_msg_data);
549: IF l_msg_count > 0 THEN
550: if (l_msg_count = 1) THEN

Line 741: p_x_prd_resrc_txn_tbl(I).OPERATION_SEQUENCE_NUM<>FND_API.G_MISS_NUM

737: END IF;
738: ---
739:
740: IF p_x_prd_resrc_txn_tbl(I).OPERATION_SEQUENCE_NUM IS NOT NULL AND
741: p_x_prd_resrc_txn_tbl(I).OPERATION_SEQUENCE_NUM<>FND_API.G_MISS_NUM
742: THEN
743: Open CurGetOperSeq(p_x_prd_resrc_txn_tbl(I).OPERATION_SEQUENCE_NUM,
744: p_x_prd_resrc_txn_tbl(I).WORKORDER_ID);
745:

Line 757: (p_x_prd_resrc_txn_tbl(I).organization_id = FND_API.G_MISS_NUM) THEN

753: Else
754: p_x_prd_resrc_txn_tbl(I).Workorder_operation_id:=l_oper_rec.workorder_operation_id;
755:
756: IF (p_x_prd_resrc_txn_tbl(I).organization_id IS NULL) OR
757: (p_x_prd_resrc_txn_tbl(I).organization_id = FND_API.G_MISS_NUM) THEN
758: p_x_prd_resrc_txn_tbl(I).organization_id:=l_oper_rec.organization_id;
759: END IF;
760:
761: -- Adithya commented out the code for bug# 6326254. Charge deparment can be different

Line 765: p_x_prd_resrc_txn_tbl(I).department_id = FND_API.G_MISS_NUM ) AND

761: -- Adithya commented out the code for bug# 6326254. Charge deparment can be different
762: -- from the operation department.
763: -- Adithya added code to default dept id/code if they are null - Bug# 6452479.
764: IF ( p_x_prd_resrc_txn_tbl(I).department_id IS NULL OR
765: p_x_prd_resrc_txn_tbl(I).department_id = FND_API.G_MISS_NUM ) AND
766: ( p_x_prd_resrc_txn_tbl(I).department_code IS NULL OR
767: p_x_prd_resrc_txn_tbl(I).department_code = FND_API.G_MISS_CHAR )
768: THEN
769: IF G_DEBUG='Y' THEN

Line 767: p_x_prd_resrc_txn_tbl(I).department_code = FND_API.G_MISS_CHAR )

763: -- Adithya added code to default dept id/code if they are null - Bug# 6452479.
764: IF ( p_x_prd_resrc_txn_tbl(I).department_id IS NULL OR
765: p_x_prd_resrc_txn_tbl(I).department_id = FND_API.G_MISS_NUM ) AND
766: ( p_x_prd_resrc_txn_tbl(I).department_code IS NULL OR
767: p_x_prd_resrc_txn_tbl(I).department_code = FND_API.G_MISS_CHAR )
768: THEN
769: IF G_DEBUG='Y' THEN
770: AHL_DEBUG_PUB.debug( 'Defaulting Dept Id and Code',l_proc_name);
771: END IF;

Line 776: p_x_prd_resrc_txn_tbl(I).department_id = FND_API.G_MISS_NUM ) AND

772: p_x_prd_resrc_txn_tbl(I).department_id:=l_oper_rec.department_id;
773: p_x_prd_resrc_txn_tbl(I).department_code:=l_oper_rec.department_code;
774: p_x_prd_resrc_txn_tbl(I).organization_id:=l_oper_rec.organization_id;
775: ELSIF ( p_x_prd_resrc_txn_tbl(I).department_id IS NULL OR
776: p_x_prd_resrc_txn_tbl(I).department_id = FND_API.G_MISS_NUM ) AND
777: ( p_x_prd_resrc_txn_tbl(I).department_code IS NOT NULL AND
778: p_x_prd_resrc_txn_tbl(I).department_code <> FND_API.G_MISS_CHAR )
779: THEN
780: OPEN CurGetDeptdet(p_x_prd_resrc_txn_tbl(I).department_code

Line 778: p_x_prd_resrc_txn_tbl(I).department_code <> FND_API.G_MISS_CHAR )

774: p_x_prd_resrc_txn_tbl(I).organization_id:=l_oper_rec.organization_id;
775: ELSIF ( p_x_prd_resrc_txn_tbl(I).department_id IS NULL OR
776: p_x_prd_resrc_txn_tbl(I).department_id = FND_API.G_MISS_NUM ) AND
777: ( p_x_prd_resrc_txn_tbl(I).department_code IS NOT NULL AND
778: p_x_prd_resrc_txn_tbl(I).department_code <> FND_API.G_MISS_CHAR )
779: THEN
780: OPEN CurGetDeptdet(p_x_prd_resrc_txn_tbl(I).department_code
781: ,p_x_prd_resrc_txn_tbl(I).organization_id);
782: FETCH CurGetDeptdet INTO p_x_prd_resrc_txn_tbl(I).department_id;

Line 802: p_x_prd_resrc_txn_tbl(I).RESOURCE_SEQUENCE_NUM<>fnd_api.g_miss_num

798: FND_MSG_PUB.ADD;
799: END IF; -- p_x_prd_resrc_txn_tbl(I).OPERATION_SEQUENCE_NUM
800:
801: If p_x_prd_resrc_txn_tbl(I).RESOURCE_SEQUENCE_NUM is not null and
802: p_x_prd_resrc_txn_tbl(I).RESOURCE_SEQUENCE_NUM<>fnd_api.g_miss_num
803: Then
804:
805: Open CurGetResSeq(p_x_prd_resrc_txn_tbl(I).WORKORDER_OPERATION_ID,
806: p_x_prd_resrc_txn_tbl(I).RESOURCE_SEQUENCE_NUM);

Line 838: p_x_prd_resrc_txn_tbl(I).Resource_Name <> fnd_api.g_miss_char) THEN

834: CLOSE CurGetResSeq;
835: Else
836: -- check resource name.
837: IF (p_x_prd_resrc_txn_tbl(I).Resource_Name is not null and
838: p_x_prd_resrc_txn_tbl(I).Resource_Name <> fnd_api.g_miss_char) THEN
839: OPEN getResID(p_x_prd_resrc_txn_tbl(I).resource_name,
840: p_x_prd_resrc_txn_tbl(I).organization_id,
841: p_x_prd_resrc_txn_tbl(I).department_id,
842: p_x_prd_resrc_txn_tbl(I).workorder_operation_id);

Line 863: p_x_prd_resrc_txn_tbl(I).department_CODE<>FND_API.G_MISS_CHAR

859: CLOSE get_wo_org_id;
860: END IF;
861:
862: IF p_x_prd_resrc_txn_tbl(I).department_CODE IS NOT NULL AND
863: p_x_prd_resrc_txn_tbl(I).department_CODE<>FND_API.G_MISS_CHAR
864: THEN
865: OPEN CurGetDeptdet(p_x_prd_resrc_txn_tbl(I).department_CODE,
866: p_x_prd_resrc_txn_tbl(I).organization_id);
867: FETCH CurGetDeptdet into l_deptrec;

Line 883: p_x_prd_resrc_txn_tbl(I).ACTIVITY_MEANING<>FND_API.G_MISS_CHAR

879: END IF;
880: */
881:
882: IF p_x_prd_resrc_txn_tbl(I).ACTIVITY_MEANING IS NOT NULL AND
883: p_x_prd_resrc_txn_tbl(I).ACTIVITY_MEANING<>FND_API.G_MISS_CHAR
884: THEN
885: OPEN CurGetActivity(p_x_prd_resrc_txn_tbl(I).ACTIVITY_MEANING);
886: FETCH CurGetActivity into p_x_prd_resrc_txn_tbl(I).ACTIVITY_ID;
887: If CurGetActivity%NOTFOUND

Line 899: p_x_prd_resrc_txn_tbl(I).REASON<>FND_API.G_MISS_CHAR

895: CLOSE CurGetActivity;
896: END IF;
897:
898: IF p_x_prd_resrc_txn_tbl(I).REASON IS NOT NULL AND
899: p_x_prd_resrc_txn_tbl(I).REASON<>FND_API.G_MISS_CHAR
900: THEN
901: OPEN CurGetReason(p_x_prd_resrc_txn_tbl(I).Reason);
902: FETCH CurGetReason into p_x_prd_resrc_txn_tbl(I).REASON_ID;
903: If CurGetReason%NOTFOUND

Line 917: p_x_prd_resrc_txn_tbl(I).serial_number<>FND_API.G_MISS_CHAR

913:
914: --Adithya commented out the following code
915: /*
916: IF p_x_prd_resrc_txn_tbl(I).serial_number IS NOT NULL AND
917: p_x_prd_resrc_txn_tbl(I).serial_number<>FND_API.G_MISS_CHAR
918: THEN
919:
920: Open get_instance_sernum (p_x_prd_resrc_txn_tbl(i).department_id,
921: p_x_prd_resrc_txn_tbl(i).serial_number);

Line 936: p_x_prd_resrc_txn_tbl(I).EMPLOYEE_NUM<>fnd_api.g_miss_CHAR

932: */
933:
934:
935: If p_x_prd_resrc_txn_tbl(I).EMPLOYEE_NUM is not null and
936: p_x_prd_resrc_txn_tbl(I).EMPLOYEE_NUM<>fnd_api.g_miss_CHAR
937: Then
938: Open CurGetEmployee(p_x_prd_resrc_txn_tbl(I).EMPLOYEE_NUM,p_x_prd_resrc_txn_tbl(I).organization_id);
939: FETCH CurGetEmployee into l_emp_rec;
940: IF CurGetEmployee%NOTFOUND

Line 975: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

971:
972: PROCEDURE PROCESS_RESOURCE_TXNS
973: (
974: p_api_version IN NUMBER := 1.0,
975: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
976: p_commit IN VARCHAR2 := FND_API.G_FALSE,
977: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
978: p_default IN VARCHAR2 := FND_API.G_FALSE,
979: p_module_type IN VARCHAR2 := NULL,

Line 976: p_commit IN VARCHAR2 := FND_API.G_FALSE,

972: PROCEDURE PROCESS_RESOURCE_TXNS
973: (
974: p_api_version IN NUMBER := 1.0,
975: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
976: p_commit IN VARCHAR2 := FND_API.G_FALSE,
977: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
978: p_default IN VARCHAR2 := FND_API.G_FALSE,
979: p_module_type IN VARCHAR2 := NULL,
980: x_return_status OUT NOCOPY VARCHAR2,

Line 977: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

973: (
974: p_api_version IN NUMBER := 1.0,
975: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
976: p_commit IN VARCHAR2 := FND_API.G_FALSE,
977: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
978: p_default IN VARCHAR2 := FND_API.G_FALSE,
979: p_module_type IN VARCHAR2 := NULL,
980: x_return_status OUT NOCOPY VARCHAR2,
981: x_msg_count OUT NOCOPY NUMBER,

Line 978: p_default IN VARCHAR2 := FND_API.G_FALSE,

974: p_api_version IN NUMBER := 1.0,
975: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
976: p_commit IN VARCHAR2 := FND_API.G_FALSE,
977: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
978: p_default IN VARCHAR2 := FND_API.G_FALSE,
979: p_module_type IN VARCHAR2 := NULL,
980: x_return_status OUT NOCOPY VARCHAR2,
981: x_msg_count OUT NOCOPY NUMBER,
982: x_msg_data OUT NOCOPY VARCHAR2,

Line 992: l_init_msg_list VARCHAR2(10):=FND_API.G_FALSE;

988: l_num_rec NUMBER;
989: l_msg_count NUMBER;
990: l_msg_data VARCHAR2(2000);
991: l_return_status VARCHAR2(1);
992: l_init_msg_list VARCHAR2(10):=FND_API.G_FALSE;
993: l_commit VARCHAR2(1):= FND_API.G_FALSE;
994: l_ahl_res_txn_tbl AHL_WIP_JOB_PVT.ahl_res_txn_tbl_type;
995: l_wip_entity_id NUMBER;
996: l_txn_group_id NUMBER;

Line 993: l_commit VARCHAR2(1):= FND_API.G_FALSE;

989: l_msg_count NUMBER;
990: l_msg_data VARCHAR2(2000);
991: l_return_status VARCHAR2(1);
992: l_init_msg_list VARCHAR2(10):=FND_API.G_FALSE;
993: l_commit VARCHAR2(1):= FND_API.G_FALSE;
994: l_ahl_res_txn_tbl AHL_WIP_JOB_PVT.ahl_res_txn_tbl_type;
995: l_wip_entity_id NUMBER;
996: l_txn_group_id NUMBER;
997: l_ctr NUMBER:=0;

Line 1037: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,

1033:
1034:
1035: -- Standard call to check for call compatibility.
1036:
1037: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
1038: p_api_version,
1039: l_api_name,G_PKG_NAME) THEN
1040: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1041: END IF;

Line 1040: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1036:
1037: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
1038: p_api_version,
1039: l_api_name,G_PKG_NAME) THEN
1040: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1041: END IF;
1042:
1043: -- Initialize message list if p_init_msg_list is set to TRUE.
1044:

Line 1045: IF FND_API.to_boolean(p_init_msg_list) THEN

1041: END IF;
1042:
1043: -- Initialize message list if p_init_msg_list is set to TRUE.
1044:
1045: IF FND_API.to_boolean(p_init_msg_list) THEN
1046: FND_MSG_PUB.initialize;
1047: END IF;
1048:
1049: -- Initialize API return status to success

Line 1051: x_return_status:=FND_API.G_RET_STS_SUCCESS;

1047: END IF;
1048:
1049: -- Initialize API return status to success
1050:
1051: x_return_status:=FND_API.G_RET_STS_SUCCESS;
1052:
1053:
1054: -- Debug info.
1055:

Line 1077: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1073: -- check error message.
1074: l_msg_count := FND_MSG_PUB.count_msg;
1075: IF l_msg_count > 0 THEN
1076: X_msg_count := l_msg_count;
1077: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1078: IF G_DEBUG='Y' THEN
1079: AHL_DEBUG_PUB.debug( 'Error Thrown in translate',L_API_NAME);
1080: END IF;
1081: RAISE FND_API.G_EXC_ERROR;

Line 1081: RAISE FND_API.G_EXC_ERROR;

1077: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1078: IF G_DEBUG='Y' THEN
1079: AHL_DEBUG_PUB.debug( 'Error Thrown in translate',L_API_NAME);
1080: END IF;
1081: RAISE FND_API.G_EXC_ERROR;
1082: END IF;
1083:
1084:
1085: -- Start of API Body

Line 1087: x_return_status:=FND_API.G_RET_STS_SUCCESS;

1083:
1084:
1085: -- Start of API Body
1086:
1087: x_return_status:=FND_API.G_RET_STS_SUCCESS;
1088:
1089: -- Validate input.
1090: VALIDATE_RES_TRNX
1091: (

Line 1104: RAISE FND_API.G_EXC_ERROR;

1100: X_msg_count := l_msg_count;
1101: IF G_DEBUG='Y' THEN
1102: AHL_DEBUG_PUB.debug( 'Error Thrown In Validation',L_API_NAME);
1103: END IF;
1104: RAISE FND_API.G_EXC_ERROR;
1105: END IF;
1106:
1107: l_ctr := 0;
1108:

Line 1113: p_x_prd_resrc_txn_tbl(i).resource_sequence_num = fnd_api.g_miss_num) THEN

1109: -- Create resource requirements if it does not exist.
1110: FOR i IN p_x_prd_resrc_txn_tbl.FIRST..p_x_prd_resrc_txn_tbl.LAST
1111: LOOP
1112: IF (p_x_prd_resrc_txn_tbl(i).resource_sequence_num is null OR
1113: p_x_prd_resrc_txn_tbl(i).resource_sequence_num = fnd_api.g_miss_num) THEN
1114:
1115: l_Resrc_Require_Tbl(l_ctr).workorder_id := p_x_prd_resrc_txn_tbl(i).workorder_id;
1116: l_Resrc_Require_Tbl(l_ctr).operation_seq_number := p_x_prd_resrc_txn_tbl(i).operation_sequence_num;
1117: -- get operation start and end dates.

Line 1165: p_init_msg_list => Fnd_Api.G_FALSE,

1161:
1162: IF (l_Resrc_Require_tbl.count > 0) THEN
1163: AHL_PP_RESRC_REQUIRE_PVT.Process_Resrc_Require (
1164: p_api_version => 1.0,
1165: p_init_msg_list => Fnd_Api.G_FALSE,
1166: p_commit => Fnd_Api.G_FALSE,
1167: p_module_type => 'JSP', -- need to pass JSP otherwise EAM api is not called.
1168: p_operation_flag => 'C',
1169: p_interface_flag => NULL,

Line 1166: p_commit => Fnd_Api.G_FALSE,

1162: IF (l_Resrc_Require_tbl.count > 0) THEN
1163: AHL_PP_RESRC_REQUIRE_PVT.Process_Resrc_Require (
1164: p_api_version => 1.0,
1165: p_init_msg_list => Fnd_Api.G_FALSE,
1166: p_commit => Fnd_Api.G_FALSE,
1167: p_module_type => 'JSP', -- need to pass JSP otherwise EAM api is not called.
1168: p_operation_flag => 'C',
1169: p_interface_flag => NULL,
1170: p_x_Resrc_Require_tbl => l_Resrc_Require_tbl,

Line 1175: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1171: x_return_status => l_return_status,
1172: x_msg_count => l_msg_count,
1173: x_msg_data => l_msg_data);
1174:
1175: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1176: IF (fnd_log.level_error >= G_DEBUG)THEN
1177: fnd_log.string
1178: (
1179: fnd_log.level_error,

Line 1184: RAISE FND_API.G_EXC_ERROR;

1180: 'ahl.plsql.AHL_PRD_RESOURCE_TRANX_PVT.Process_Resource_Txns',
1181: 'AHL_PP_RESRC_REQUIRE_PVT.Process_Resrc_Require API returned error'
1182: );
1183: END IF;
1184: RAISE FND_API.G_EXC_ERROR;
1185: END IF;
1186:
1187: END IF;
1188:

Line 1293: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1289:
1290: l_msg_count := FND_MSG_PUB.count_msg;
1291: IF l_msg_count > 0 THEN
1292: X_msg_count := l_msg_count;
1293: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1294: RAISE FND_API.G_EXC_ERROR;
1295: IF G_DEBUG='Y' THEN
1296: AHL_DEBUG_PUB.debug( 'Validation Errors in interface API');
1297: END IF;

Line 1294: RAISE FND_API.G_EXC_ERROR;

1290: l_msg_count := FND_MSG_PUB.count_msg;
1291: IF l_msg_count > 0 THEN
1292: X_msg_count := l_msg_count;
1293: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1294: RAISE FND_API.G_EXC_ERROR;
1295: IF G_DEBUG='Y' THEN
1296: AHL_DEBUG_PUB.debug( 'Validation Errors in interface API');
1297: END IF;
1298:

Line 1304: IF FND_API.TO_BOOLEAN(p_commit) THEN

1300:
1301: --Adithya added
1302: X_msg_count := l_msg_count;
1303:
1304: IF FND_API.TO_BOOLEAN(p_commit) THEN
1305: COMMIT;
1306: END IF;
1307:
1308: -- Debug info

Line 1321: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1317:
1318: END IF;
1319:
1320: EXCEPTION
1321: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1322: ROLLBACK TO PROCESS_RESOURCE_TRANX;
1323: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1324: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1325: p_count => x_msg_count,

Line 1323: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1319:
1320: EXCEPTION
1321: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1322: ROLLBACK TO PROCESS_RESOURCE_TRANX;
1323: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1324: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1325: p_count => x_msg_count,
1326: p_data => x_msg_data);
1327:

Line 1324: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

1320: EXCEPTION
1321: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1322: ROLLBACK TO PROCESS_RESOURCE_TRANX;
1323: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1324: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1325: p_count => x_msg_count,
1326: p_data => x_msg_data);
1327:
1328: WHEN FND_API.G_EXC_ERROR THEN

Line 1328: WHEN FND_API.G_EXC_ERROR THEN

1324: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1325: p_count => x_msg_count,
1326: p_data => x_msg_data);
1327:
1328: WHEN FND_API.G_EXC_ERROR THEN
1329: ROLLBACK TO PROCESS_RESOURCE_TRANX;
1330: X_return_status := FND_API.G_RET_STS_ERROR;
1331: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1332: p_count => x_msg_count,

Line 1330: X_return_status := FND_API.G_RET_STS_ERROR;

1326: p_data => x_msg_data);
1327:
1328: WHEN FND_API.G_EXC_ERROR THEN
1329: ROLLBACK TO PROCESS_RESOURCE_TRANX;
1330: X_return_status := FND_API.G_RET_STS_ERROR;
1331: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1332: p_count => x_msg_count,
1333: p_data => X_msg_data);
1334: WHEN OTHERS THEN

Line 1331: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

1327:
1328: WHEN FND_API.G_EXC_ERROR THEN
1329: ROLLBACK TO PROCESS_RESOURCE_TRANX;
1330: X_return_status := FND_API.G_RET_STS_ERROR;
1331: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1332: p_count => x_msg_count,
1333: p_data => X_msg_data);
1334: WHEN OTHERS THEN
1335: ROLLBACK TO PROCESS_RESOURCE_TRANX;

Line 1336: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1332: p_count => x_msg_count,
1333: p_data => X_msg_data);
1334: WHEN OTHERS THEN
1335: ROLLBACK TO PROCESS_RESOURCE_TRANX;
1336: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1337: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1338: THEN
1339: fnd_msg_pub.add_exc_msg(p_pkg_name =>G_PKG_NAME,
1340: p_procedure_name =>l_api_name,

Line 1344: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

1340: p_procedure_name =>l_api_name,
1341: p_error_text =>SUBSTR(SQLERRM,1,240)
1342: );
1343: END IF;
1344: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1345: p_count => x_msg_count,
1346: p_data => X_msg_data);
1347:
1348: END;

Line 1379: p_prd_myworkorder_txn_tbl(i).TRANSACTED_HOURS <> fnd_api.g_miss_num

1375: -- rroy
1376: -- R12 Tech UIs
1377: -- Negative resource transactions are allowed starting R12
1378: /*IF p_prd_myworkorder_txn_tbl(i).TRANSACTED_HOURS IS NOT NULL OR
1379: p_prd_myworkorder_txn_tbl(i).TRANSACTED_HOURS <> fnd_api.g_miss_num
1380: THEN
1381: IF p_prd_myworkorder_txn_tbl(i).TRANSACTED_HOURS < 0
1382: THEN
1383: FND_MESSAGE.set_name('AHL','AHL_PRD_RESTXN_QTY_INVALID');

Line 1397: p_prd_myworkorder_txn_tbl(i).WORKORDER_ID = fnd_api.g_miss_num

1393: -- rroy
1394: -- R12 Tech UIs
1395:
1396: IF p_prd_myworkorder_txn_tbl(i).WORKORDER_ID IS NULL OR
1397: p_prd_myworkorder_txn_tbl(i).WORKORDER_ID = fnd_api.g_miss_num
1398: THEN
1399: FND_MESSAGE.set_name('AHL','AHL_PRD_WORKORDER_ID_NULL');
1400: FND_MSG_PUB.ADD;
1401: IF G_DEBUG='Y' THEN

Line 1414: IF l_return_status = FND_API.G_TRUE THEN

1410: p_workorder_id => p_prd_myworkorder_txn_tbl(i).workorder_id,
1411: p_ue_id => NULL,
1412: p_visit_id => NULL,
1413: p_item_instance_id => NULL);
1414: IF l_return_status = FND_API.G_TRUE THEN
1415: OPEN get_wo_details(p_prd_myworkorder_txn_tbl(i).workorder_id);
1416: FETCH get_wo_details INTO l_wo_name;
1417: CLOSE get_wo_details;
1418: FND_MESSAGE.Set_Name('AHL', 'AHL_PP_RESTXN_UNTLCKD');

Line 1426: p_prd_myworkorder_txn_tbl(i).OPERATION_SEQUENCE = fnd_api.g_miss_num

1422: END IF;
1423: -- rroy
1424: -- ACL Changes
1425: IF p_prd_myworkorder_txn_tbl(i).OPERATION_SEQUENCE IS NULL OR
1426: p_prd_myworkorder_txn_tbl(i).OPERATION_SEQUENCE = fnd_api.g_miss_num
1427: THEN
1428: FND_MESSAGE.set_name('AHL','AHL_PRD_OPERATION_NULL');
1429: FND_MSG_PUB.ADD;
1430: IF G_DEBUG='Y' THEN

Line 1436: p_prd_myworkorder_txn_tbl(i).RESOURCE_SEQUENCE = fnd_api.g_miss_num

1432: END IF;
1433: END IF ;
1434:
1435: IF p_prd_myworkorder_txn_tbl(i).RESOURCE_SEQUENCE IS NULL OR
1436: p_prd_myworkorder_txn_tbl(i).RESOURCE_SEQUENCE = fnd_api.g_miss_num
1437: THEN
1438: FND_MESSAGE.set_name('AHL','AHL_PRD_RESOURCE_NULL');
1439: FND_MSG_PUB.ADD;
1440: IF G_DEBUG='Y' THEN

Line 1502: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

1498:
1499: PROCEDURE PROCESS_MYWORKORDER_TXNS
1500: (
1501: p_api_version IN NUMBER := 1.0,
1502: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1503: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1504: p_validation_level IN NUMBER:=FND_API.G_VALID_LEVEL_FULL,
1505: p_default IN VARCHAR2 := FND_API.G_FALSE,
1506: p_module_type IN VARCHAR2 := NULL,

Line 1503: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1499: PROCEDURE PROCESS_MYWORKORDER_TXNS
1500: (
1501: p_api_version IN NUMBER := 1.0,
1502: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1503: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1504: p_validation_level IN NUMBER:=FND_API.G_VALID_LEVEL_FULL,
1505: p_default IN VARCHAR2 := FND_API.G_FALSE,
1506: p_module_type IN VARCHAR2 := NULL,
1507: x_return_status OUT NOCOPY VARCHAR2,

Line 1504: p_validation_level IN NUMBER:=FND_API.G_VALID_LEVEL_FULL,

1500: (
1501: p_api_version IN NUMBER := 1.0,
1502: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1503: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1504: p_validation_level IN NUMBER:=FND_API.G_VALID_LEVEL_FULL,
1505: p_default IN VARCHAR2 := FND_API.G_FALSE,
1506: p_module_type IN VARCHAR2 := NULL,
1507: x_return_status OUT NOCOPY VARCHAR2,
1508: x_msg_count OUT NOCOPY NUMBER,

Line 1505: p_default IN VARCHAR2 := FND_API.G_FALSE,

1501: p_api_version IN NUMBER := 1.0,
1502: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1503: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1504: p_validation_level IN NUMBER:=FND_API.G_VALID_LEVEL_FULL,
1505: p_default IN VARCHAR2 := FND_API.G_FALSE,
1506: p_module_type IN VARCHAR2 := NULL,
1507: x_return_status OUT NOCOPY VARCHAR2,
1508: x_msg_count OUT NOCOPY NUMBER,
1509: x_msg_data OUT NOCOPY VARCHAR2,

Line 1521: l_init_msg_list VARCHAR2(10):=FND_API.G_FALSE;

1517: l_num_rec NUMBER;
1518: l_msg_count NUMBER;
1519: l_msg_data VARCHAR2(2000);
1520: l_return_status VARCHAR2(1);
1521: l_init_msg_list VARCHAR2(10):=FND_API.G_FALSE;
1522: l_commit VARCHAR2(1):= FND_API.G_FALSE;
1523: l_ahl_res_txn_tbl AHL_WIP_JOB_PVT.ahl_res_txn_tbl_type;
1524: l_wip_entity_id NUMBER;
1525: l_txn_group_id NUMBER;

Line 1522: l_commit VARCHAR2(1):= FND_API.G_FALSE;

1518: l_msg_count NUMBER;
1519: l_msg_data VARCHAR2(2000);
1520: l_return_status VARCHAR2(1);
1521: l_init_msg_list VARCHAR2(10):=FND_API.G_FALSE;
1522: l_commit VARCHAR2(1):= FND_API.G_FALSE;
1523: l_ahl_res_txn_tbl AHL_WIP_JOB_PVT.ahl_res_txn_tbl_type;
1524: l_wip_entity_id NUMBER;
1525: l_txn_group_id NUMBER;
1526: l_ctr NUMBER:=0;

Line 1591: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,

1587:
1588:
1589: -- Standard call to check for call compatibility.
1590:
1591: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
1592: p_api_version,
1593: l_api_name,G_PKG_NAME) THEN
1594: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1595: END IF;

Line 1594: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1590:
1591: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
1592: p_api_version,
1593: l_api_name,G_PKG_NAME) THEN
1594: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1595: END IF;
1596:
1597: -- Initialize message list if p_init_msg_list is set to TRUE.
1598:

Line 1599: IF FND_API.to_boolean(p_init_msg_list) THEN

1595: END IF;
1596:
1597: -- Initialize message list if p_init_msg_list is set to TRUE.
1598:
1599: IF FND_API.to_boolean(p_init_msg_list) THEN
1600: FND_MSG_PUB.initialize;
1601: END IF;
1602:
1603: -- Initialize API return status to success

Line 1605: x_return_status:=FND_API.G_RET_STS_SUCCESS;

1601: END IF;
1602:
1603: -- Initialize API return status to success
1604:
1605: x_return_status:=FND_API.G_RET_STS_SUCCESS;
1606:
1607:
1608: -- Debug info.
1609:

Line 1623: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1619:
1620: l_msg_count := FND_MSG_PUB.count_msg;
1621: IF l_msg_count > 0 THEN
1622: X_msg_count := l_msg_count;
1623: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1624: IF G_DEBUG='Y' THEN
1625: AHL_DEBUG_PUB.debug( 'Error Thrown in Validate',L_API_NAME);
1626: END IF;
1627: RAISE FND_API.G_EXC_ERROR;

Line 1627: RAISE FND_API.G_EXC_ERROR;

1623: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1624: IF G_DEBUG='Y' THEN
1625: AHL_DEBUG_PUB.debug( 'Error Thrown in Validate',L_API_NAME);
1626: END IF;
1627: RAISE FND_API.G_EXC_ERROR;
1628: END IF;
1629: -- Get the Defalut UOM Code --- Hr
1630: Open getDefaultUOM;
1631: fetch getDefaultUOM into l_uom_code;

Line 1650: RAISE FND_API.G_EXC_ERROR;

1646: CLOSE GetWipid;
1647: IF l_wo_status_code IN ('1', '12', '7', '6', '13', '5') THEN
1648: FND_MESSAGE.set_name('AHL', 'AHL_PRD_RESOURCE_CANNOTEDIT');
1649: FND_MSG_PUB.ADD;
1650: RAISE FND_API.G_EXC_ERROR;
1651: END IF;
1652:
1653: Open getResDetails(p_x_prd_myworkorder_txn_tbl(i).ASSIGNMENT_ID);
1654: FETCH getResDetails into l_res_rec;

Line 1700: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1696: End if;
1697: l_msg_count := FND_MSG_PUB.count_msg;
1698: IF l_msg_count > 0 THEN
1699: X_msg_count := l_msg_count;
1700: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1701: RAISE FND_API.G_EXC_ERROR;
1702: IF G_DEBUG='Y' THEN
1703: AHL_DEBUG_PUB.debug( 'Error in Insert_Resource_Txn API');
1704: END IF;

Line 1701: RAISE FND_API.G_EXC_ERROR;

1697: l_msg_count := FND_MSG_PUB.count_msg;
1698: IF l_msg_count > 0 THEN
1699: X_msg_count := l_msg_count;
1700: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1701: RAISE FND_API.G_EXC_ERROR;
1702: IF G_DEBUG='Y' THEN
1703: AHL_DEBUG_PUB.debug( 'Error in Insert_Resource_Txn API');
1704: END IF;
1705: END IF;

Line 1716: p_x_prd_myworkorder_txn_tbl(i).OPERATION_COMPLETE <> FND_API.G_MISS_CHAR AND

1712:
1713:
1714:
1715: IF (p_x_prd_myworkorder_txn_tbl(i).OPERATION_COMPLETE IS NOT NULL AND
1716: p_x_prd_myworkorder_txn_tbl(i).OPERATION_COMPLETE <> FND_API.G_MISS_CHAR AND
1717: p_x_prd_myworkorder_txn_tbl(i).OPERATION_COMPLETE = 'Y')
1718: THEN
1719: getOperationRecord(
1720: p_operation_id => p_x_prd_myworkorder_txn_tbl(i).WORKORDER_OPERATION_ID,

Line 1736: p_init_msg_list =>FND_API.G_FALSE,

1732: Then
1733: AHL_PRD_OPERATIONS_PVT.PROCESS_OPERATIONS
1734: (
1735: p_api_version =>1.0,
1736: p_init_msg_list =>FND_API.G_FALSE,
1737: p_commit =>l_commit,
1738: p_validation_level =>p_validation_level,
1739: p_default => FND_API.G_TRUE,
1740: p_module_type => NULL,

Line 1739: p_default => FND_API.G_TRUE,

1735: p_api_version =>1.0,
1736: p_init_msg_list =>FND_API.G_FALSE,
1737: p_commit =>l_commit,
1738: p_validation_level =>p_validation_level,
1739: p_default => FND_API.G_TRUE,
1740: p_module_type => NULL,
1741: p_wip_mass_load_flag => 'N',
1742: x_return_status =>x_return_status,
1743: x_msg_count =>l_msg_count,

Line 1751: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1747: End if;
1748: l_msg_count := FND_MSG_PUB.count_msg;
1749: IF l_msg_count > 0 THEN
1750: X_msg_count := l_msg_count;
1751: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1752: RAISE FND_API.G_EXC_ERROR;
1753: IF G_DEBUG='Y' THEN
1754: AHL_DEBUG_PUB.debug( 'Error in Process Operations API');
1755: END IF;

Line 1752: RAISE FND_API.G_EXC_ERROR;

1748: l_msg_count := FND_MSG_PUB.count_msg;
1749: IF l_msg_count > 0 THEN
1750: X_msg_count := l_msg_count;
1751: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1752: RAISE FND_API.G_EXC_ERROR;
1753: IF G_DEBUG='Y' THEN
1754: AHL_DEBUG_PUB.debug( 'Error in Process Operations API');
1755: END IF;
1756: END IF;

Line 1765: p_init_msg_list => FND_API.G_TRUE,

1761: LOOP
1762: AHL_COMPLETIONS_PVT.complete_operation
1763: (
1764: p_api_version => 1.0,
1765: p_init_msg_list => FND_API.G_TRUE,
1766: p_commit => FND_API.G_FALSE,
1767: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1768: p_default => FND_API.G_FALSE,
1769: p_module_type => NULL,

Line 1766: p_commit => FND_API.G_FALSE,

1762: AHL_COMPLETIONS_PVT.complete_operation
1763: (
1764: p_api_version => 1.0,
1765: p_init_msg_list => FND_API.G_TRUE,
1766: p_commit => FND_API.G_FALSE,
1767: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1768: p_default => FND_API.G_FALSE,
1769: p_module_type => NULL,
1770: x_return_status => x_return_status,

Line 1767: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1763: (
1764: p_api_version => 1.0,
1765: p_init_msg_list => FND_API.G_TRUE,
1766: p_commit => FND_API.G_FALSE,
1767: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1768: p_default => FND_API.G_FALSE,
1769: p_module_type => NULL,
1770: x_return_status => x_return_status,
1771: x_msg_count => l_msg_count,

Line 1768: p_default => FND_API.G_FALSE,

1764: p_api_version => 1.0,
1765: p_init_msg_list => FND_API.G_TRUE,
1766: p_commit => FND_API.G_FALSE,
1767: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1768: p_default => FND_API.G_FALSE,
1769: p_module_type => NULL,
1770: x_return_status => x_return_status,
1771: x_msg_count => l_msg_count,
1772: x_msg_data => l_msg_data,

Line 1781: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1777: END IF;
1778: l_msg_count := FND_MSG_PUB.count_msg;
1779: IF l_msg_count > 0 THEN
1780: X_msg_count := l_msg_count;
1781: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1782: RAISE FND_API.G_EXC_ERROR;
1783: IF G_DEBUG='Y' THEN
1784: AHL_DEBUG_PUB.debug( 'Error in Complete Operation API');
1785: END IF;

Line 1782: RAISE FND_API.G_EXC_ERROR;

1778: l_msg_count := FND_MSG_PUB.count_msg;
1779: IF l_msg_count > 0 THEN
1780: X_msg_count := l_msg_count;
1781: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1782: RAISE FND_API.G_EXC_ERROR;
1783: IF G_DEBUG='Y' THEN
1784: AHL_DEBUG_PUB.debug( 'Error in Complete Operation API');
1785: END IF;
1786: END IF;

Line 1788: IF FND_API.TO_BOOLEAN(p_commit) THEN

1784: AHL_DEBUG_PUB.debug( 'Error in Complete Operation API');
1785: END IF;
1786: END IF;
1787:
1788: IF FND_API.TO_BOOLEAN(p_commit) THEN
1789: COMMIT;
1790: END IF;
1791:
1792: -- Debug info

Line 1804: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1800: AHL_DEBUG_PUB.disable_debug;
1801: END IF;
1802:
1803: EXCEPTION
1804: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1805: ROLLBACK TO PROCESS_MYWORKORDER_TXNS;
1806: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1807: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1808: p_count => x_msg_count,

Line 1806: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1802:
1803: EXCEPTION
1804: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1805: ROLLBACK TO PROCESS_MYWORKORDER_TXNS;
1806: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1807: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1808: p_count => x_msg_count,
1809: p_data => x_msg_data);
1810:

Line 1807: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

1803: EXCEPTION
1804: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1805: ROLLBACK TO PROCESS_MYWORKORDER_TXNS;
1806: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1807: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1808: p_count => x_msg_count,
1809: p_data => x_msg_data);
1810:
1811: WHEN FND_API.G_EXC_ERROR THEN

Line 1811: WHEN FND_API.G_EXC_ERROR THEN

1807: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1808: p_count => x_msg_count,
1809: p_data => x_msg_data);
1810:
1811: WHEN FND_API.G_EXC_ERROR THEN
1812: ROLLBACK TO PROCESS_MYWORKORDER_TXNS;
1813: X_return_status := FND_API.G_RET_STS_ERROR;
1814: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1815: p_count => x_msg_count,

Line 1813: X_return_status := FND_API.G_RET_STS_ERROR;

1809: p_data => x_msg_data);
1810:
1811: WHEN FND_API.G_EXC_ERROR THEN
1812: ROLLBACK TO PROCESS_MYWORKORDER_TXNS;
1813: X_return_status := FND_API.G_RET_STS_ERROR;
1814: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1815: p_count => x_msg_count,
1816: p_data => X_msg_data);
1817: WHEN OTHERS THEN

Line 1814: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

1810:
1811: WHEN FND_API.G_EXC_ERROR THEN
1812: ROLLBACK TO PROCESS_MYWORKORDER_TXNS;
1813: X_return_status := FND_API.G_RET_STS_ERROR;
1814: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1815: p_count => x_msg_count,
1816: p_data => X_msg_data);
1817: WHEN OTHERS THEN
1818: ROLLBACK TO PROCESS_MYWORKORDER_TXNS;

Line 1819: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1815: p_count => x_msg_count,
1816: p_data => X_msg_data);
1817: WHEN OTHERS THEN
1818: ROLLBACK TO PROCESS_MYWORKORDER_TXNS;
1819: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1820: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1821: THEN
1822: fnd_msg_pub.add_exc_msg(p_pkg_name =>G_PKG_NAME,
1823: p_procedure_name =>l_api_name,

Line 1827: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

1823: p_procedure_name =>l_api_name,
1824: p_error_text =>SUBSTR(SQLERRM,1,240)
1825: );
1826: END IF;
1827: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1828: p_count => x_msg_count,
1829: p_data => X_msg_data);
1830:
1831: END;

Line 1905: --# p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

1901: --# PROCEDURE: Get_Resource_Txn_Defaults
1902: --# PARAMETERS
1903: --# Standard IN Parameters
1904: --# p_api_version IN NUMBER := 1.0
1905: --# p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1906: --# p_module_type IN VARCHAR2 := NULL
1907: --#
1908: --# Standard OUT Parameters
1909: --# x_return_status OUT NOCOPY VARCHAR2

Line 1930: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

1926:
1927: PROCEDURE Get_Resource_Txn_Defaults
1928: (
1929: p_api_version IN NUMBER := 1.0,
1930: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1931: p_module_type IN VARCHAR2 := NULL,
1932: x_return_status OUT NOCOPY VARCHAR2,
1933: x_msg_count OUT NOCOPY NUMBER,
1934: x_msg_data OUT NOCOPY VARCHAR2,