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

Line 45: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

41: *********************************************************************/
42: PROCEDURE Add_WO_To_Network
43: (
44: p_api_version IN NUMBER,
45: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
46: p_commit IN VARCHAR2 := FND_API.G_FALSE,
47: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
48:
49: p_child_object_id IN NUMBER,

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

42: PROCEDURE Add_WO_To_Network
43: (
44: p_api_version IN NUMBER,
45: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
46: p_commit IN VARCHAR2 := FND_API.G_FALSE,
47: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
48:
49: p_child_object_id IN NUMBER,
50: p_child_object_type_id IN NUMBER,

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

43: (
44: p_api_version IN NUMBER,
45: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
46: p_commit IN VARCHAR2 := FND_API.G_FALSE,
47: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
48:
49: p_child_object_id IN NUMBER,
50: p_child_object_type_id IN NUMBER,
51: p_parent_object_id IN NUMBER,

Line 53: p_adjust_parent IN VARCHAR2 := FND_API.G_FALSE,

49: p_child_object_id IN NUMBER,
50: p_child_object_type_id IN NUMBER,
51: p_parent_object_id IN NUMBER,
52: p_parent_object_type_id IN NUMBER,
53: p_adjust_parent IN VARCHAR2 := FND_API.G_FALSE,
54: p_relationship_type IN NUMBER := 1,
55:
56: x_return_status OUT NOCOPY VARCHAR2,
57: x_msg_count OUT NOCOPY NUMBER,

Line 71: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

67: l_work_object_id NUMBER;
68: l_work_object_type_id NUMBER;
69:
70: l_stmt_num NUMBER;
71: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
72: l_msg_count NUMBER;
73: l_msg_data VARCHAR2(1000);
74:
75: l_exception_msg VARCHAR2(1000);

Line 135: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

131: -- Standard Start of API savepoint
132: SAVEPOINT EAM_WN_ADD_WO;
133:
134: -- Standard call to check for call compatibility.
135: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
136: p_api_version ,
137: l_api_name ,
138: G_PKG_NAME )
139: THEN

Line 140: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

136: p_api_version ,
137: l_api_name ,
138: G_PKG_NAME )
139: THEN
140: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
141: END IF;
142: -- Initialize message list if p_init_msg_list is set to TRUE.
143: IF FND_API.to_Boolean( p_init_msg_list ) THEN
144: FND_MSG_PUB.initialize;

Line 143: IF FND_API.to_Boolean( p_init_msg_list ) THEN

139: THEN
140: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
141: END IF;
142: -- Initialize message list if p_init_msg_list is set to TRUE.
143: IF FND_API.to_Boolean( p_init_msg_list ) THEN
144: FND_MSG_PUB.initialize;
145: END IF;
146: -- Initialize API return status to success
147: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 147: x_return_status := FND_API.G_RET_STS_SUCCESS;

143: IF FND_API.to_Boolean( p_init_msg_list ) THEN
144: FND_MSG_PUB.initialize;
145: END IF;
146: -- Initialize API return status to success
147: x_return_status := FND_API.G_RET_STS_SUCCESS;
148: -- API body
149:
150:
151: x_return_status := l_return_status;

Line 334: x_return_status := FND_API.G_RET_STS_ERROR;

330: );
331:
332: x_mesg_token_tbl := l_out_mesg_token_tbl;
333:
334: x_return_status := FND_API.G_RET_STS_ERROR;
335: return;
336: END IF;
337:
338: --fix for 3433757.added validation so that relationships can't be created if either

Line 363: x_return_status := FND_API.G_RET_STS_ERROR;

359: l_mesg_token_tbl := l_out_mesg_token_tbl;
360:
361: x_mesg_token_tbl := l_out_mesg_token_tbl;
362:
363: x_return_status := FND_API.G_RET_STS_ERROR;
364: return;
365: END IF;
366:
367:

Line 458: p_init_msg_list => FND_API.G_FALSE,

454: x_return_status => l_return_status,
455: x_msg_count => l_msg_count,
456: x_msg_data => l_msg_data,
457: p_api_version => 1.0,
458: p_init_msg_list => FND_API.G_FALSE,
459: p_commit => FND_API.G_FALSE);
460:
461: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
462:

Line 459: p_commit => FND_API.G_FALSE);

455: x_msg_count => l_msg_count,
456: x_msg_data => l_msg_data,
457: p_api_version => 1.0,
458: p_init_msg_list => FND_API.G_FALSE,
459: p_commit => FND_API.G_FALSE);
460:
461: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
462:
463: l_token_tbl(1).token_name := 'Parent Object Id';

Line 461: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

457: p_api_version => 1.0,
458: p_init_msg_list => FND_API.G_FALSE,
459: p_commit => FND_API.G_FALSE);
460:
461: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
462:
463: l_token_tbl(1).token_name := 'Parent Object Id';
464: l_token_tbl(1).token_value := l_parent_object_id;
465:

Line 671: p_init_msg_list => FND_API.G_FALSE,

667:
668: EAM_WO_NETWORK_VALIDATE_PVT.Validate_Structure
669: (
670: p_api_version => 1.0,
671: p_init_msg_list => FND_API.G_FALSE,
672: p_commit => FND_API.G_FALSE,
673: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
674:
675: p_work_object_id => l_child_object_id,

Line 672: p_commit => FND_API.G_FALSE,

668: EAM_WO_NETWORK_VALIDATE_PVT.Validate_Structure
669: (
670: p_api_version => 1.0,
671: p_init_msg_list => FND_API.G_FALSE,
672: p_commit => FND_API.G_FALSE,
673: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
674:
675: p_work_object_id => l_child_object_id,
676: p_work_object_type_id => l_child_object_type_id,

Line 673: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

669: (
670: p_api_version => 1.0,
671: p_init_msg_list => FND_API.G_FALSE,
672: p_commit => FND_API.G_FALSE,
673: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
674:
675: p_work_object_id => l_child_object_id,
676: p_work_object_type_id => l_child_object_type_id,
677: p_exception_logging => 'Y',

Line 692: IF l_return_status = FND_API.G_RET_STS_ERROR OR

688: --dbms_output.put_line('After VALIDATE_STRUCTURE:ret stat ='||l_return_status);
689:
690:
691:
692: IF l_return_status = FND_API.G_RET_STS_ERROR OR
693: l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
694:
695: l_token_tbl(1).token_name := 'Parent_WorkOrder';
696: l_token_tbl(1).token_value := l_parent_workorder;

Line 693: l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

689:
690:
691:
692: IF l_return_status = FND_API.G_RET_STS_ERROR OR
693: l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
694:
695: l_token_tbl(1).token_name := 'Parent_WorkOrder';
696: l_token_tbl(1).token_value := l_parent_workorder;
697: l_token_tbl(2).token_name := 'Child_WorkOrder';

Line 721: IF FND_API.To_Boolean( p_commit ) THEN

717: end if; --bug 7943516
718:
719: -- End of API body.
720: -- Standard check of p_commit.
721: IF FND_API.To_Boolean( p_commit ) THEN
722: --dbms_output.put_line('committing');
723: COMMIT WORK;
724: END IF;
725:

Line 733: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

729: WHEN OTHERS THEN
730:
731: rollback to EAM_WN_ADD_WO;
732:
733: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
734:
735: l_token_tbl(1).token_name := 'Parent_WorkOrder';
736: l_token_tbl(1).token_value := l_parent_workorder;
737: l_token_tbl(2).token_name := 'Child_WorkOrder';

Line 851: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

847: /*Bug3521886: Pass requested start date and due date*/
848: PROCEDURE Resize_WO
849: (
850: p_api_version IN NUMBER,
851: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
852: p_commit IN VARCHAR2 := FND_API.G_FALSE,
853: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
854: p_object_id IN NUMBER,
855: p_object_type_id IN NUMBER,

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

848: PROCEDURE Resize_WO
849: (
850: p_api_version IN NUMBER,
851: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
852: p_commit IN VARCHAR2 := FND_API.G_FALSE,
853: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
854: p_object_id IN NUMBER,
855: p_object_type_id IN NUMBER,
856: p_start_date IN DATE,

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

849: (
850: p_api_version IN NUMBER,
851: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
852: p_commit IN VARCHAR2 := FND_API.G_FALSE,
853: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
854: p_object_id IN NUMBER,
855: p_object_type_id IN NUMBER,
856: p_start_date IN DATE,
857: p_completion_date IN DATE,

Line 875: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

871: l_object_type_id NUMBER := p_object_type_id;
872: l_start_date DATE := p_start_date;
873: l_completion_date DATE := p_completion_date;
874:
875: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
876: l_msg_count NUMBER;
877: l_msg_data VARCHAR2(1000);
878:
879: l_date_chk_return_status VARCHAR2(1);

Line 999: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

995: );
996:
997: /* if the status returned is sucess then commit the work in case caller wants it to be committed. Else * raise exception
998: */
999: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1000: IF FND_API.TO_BOOLEAN(p_commit)THEN
1001: COMMIT WORK;
1002: END IF;
1003: ELSE

Line 1000: IF FND_API.TO_BOOLEAN(p_commit)THEN

996:
997: /* if the status returned is sucess then commit the work in case caller wants it to be committed. Else * raise exception
998: */
999: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1000: IF FND_API.TO_BOOLEAN(p_commit)THEN
1001: COMMIT WORK;
1002: END IF;
1003: ELSE
1004: RAISE FND_API.G_EXC_ERROR;

Line 1004: RAISE FND_API.G_EXC_ERROR;

1000: IF FND_API.TO_BOOLEAN(p_commit)THEN
1001: COMMIT WORK;
1002: END IF;
1003: ELSE
1004: RAISE FND_API.G_EXC_ERROR;
1005: END IF;
1006:
1007: EXCEPTION
1008: when others then

Line 1009: x_return_status := FND_API.G_RET_STS_ERROR;

1005: END IF;
1006:
1007: EXCEPTION
1008: when others then
1009: x_return_status := FND_API.G_RET_STS_ERROR;
1010: return;
1011:
1012:
1013: END Resize_WO;

Line 1022: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1018:
1019: PROCEDURE Delete_Dependency
1020: (
1021: p_api_version IN NUMBER,
1022: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1023: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1024: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1025:
1026: p_prior_object_id IN NUMBER,

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

1019: PROCEDURE Delete_Dependency
1020: (
1021: p_api_version IN NUMBER,
1022: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1023: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1024: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1025:
1026: p_prior_object_id IN NUMBER,
1027: p_prior_object_type_id IN NUMBER,

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

1020: (
1021: p_api_version IN NUMBER,
1022: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1023: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1024: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1025:
1026: p_prior_object_id IN NUMBER,
1027: p_prior_object_type_id IN NUMBER,
1028: p_next_object_id IN NUMBER,

Line 1046: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

1042: l_count_prior NUMBER := 0;
1043: l_count_next NUMBER := 0;
1044: l_status_type NUMBER := 0;
1045:
1046: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1047: l_msg_count NUMBER;
1048: l_msg_data VARCHAR2(1000);
1049: l_sched_relationship_id NUMBER;
1050:

Line 1160: p_init_msg_list => FND_API.G_FALSE,

1156: x_return_status => l_return_status,
1157: x_msg_count => l_msg_count,
1158: x_msg_data => l_msg_data,
1159: p_api_version => 1.0,
1160: p_init_msg_list => FND_API.G_FALSE,
1161: p_commit => FND_API.G_FALSE);
1162:
1163: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1164:

Line 1161: p_commit => FND_API.G_FALSE);

1157: x_msg_count => l_msg_count,
1158: x_msg_data => l_msg_data,
1159: p_api_version => 1.0,
1160: p_init_msg_list => FND_API.G_FALSE,
1161: p_commit => FND_API.G_FALSE);
1162:
1163: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1164:
1165: l_token_tbl(1).token_name := 'Parent Object Id';

Line 1163: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

1159: p_api_version => 1.0,
1160: p_init_msg_list => FND_API.G_FALSE,
1161: p_commit => FND_API.G_FALSE);
1162:
1163: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1164:
1165: l_token_tbl(1).token_name := 'Parent Object Id';
1166: l_token_tbl(1).token_value := l_prior_object_id;
1167:

Line 1191: x_return_status := FND_API.G_RET_STS_SUCCESS;

1187: and child_object_id = l_next_object_id
1188: and child_object_type_id = l_next_object_type_id
1189: and parent_relationship_type = 2;
1190:
1191: x_return_status := FND_API.G_RET_STS_SUCCESS;
1192:
1193: EXCEPTION
1194: when others then
1195:

Line 1214: x_return_status := FND_API.G_RET_STS_ERROR;

1210: l_mesg_token_tbl := l_out_mesg_token_tbl;
1211:
1212: x_mesg_token_tbl := l_out_mesg_token_tbl;
1213:
1214: x_return_status := FND_API.G_RET_STS_ERROR;
1215: return;
1216:
1217: END Delete_Dependency;
1218:

Line 1225: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1221:
1222: PROCEDURE Add_Dependency
1223: (
1224: p_api_version IN NUMBER,
1225: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1226: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1227: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1228:
1229: p_prior_object_id IN NUMBER,

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

1222: PROCEDURE Add_Dependency
1223: (
1224: p_api_version IN NUMBER,
1225: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1226: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1227: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1228:
1229: p_prior_object_id IN NUMBER,
1230: p_prior_object_type_id IN NUMBER,

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

1223: (
1224: p_api_version IN NUMBER,
1225: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1226: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1227: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1228:
1229: p_prior_object_id IN NUMBER,
1230: p_prior_object_type_id IN NUMBER,
1231: p_next_object_id IN NUMBER,

Line 1261: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

1257: l_relationship_status NUMBER := 0; -- pending validation
1258:
1259: l_count NUMBER := 0;
1260: l_status_type NUMBER := 0;
1261: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1262: l_msg_count NUMBER;
1263: l_msg_data VARCHAR2(1000);
1264: l_err_text VARCHAR2(2000) := NULL;
1265: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

Line 1500: x_return_status := FND_API.G_RET_STS_ERROR;

1496: l_mesg_token_tbl := l_out_mesg_token_tbl;
1497:
1498: x_mesg_token_tbl := l_out_mesg_token_tbl;
1499:
1500: x_return_status := FND_API.G_RET_STS_ERROR;
1501: return;
1502: END IF;
1503:
1504: wip_sched_relation_grp.insertRow(

Line 1515: p_init_msg_list => FND_API.G_FALSE,

1511: x_return_status => l_return_status,
1512: x_msg_count => l_msg_count,
1513: x_msg_data => l_msg_data,
1514: p_api_version => 1.0,
1515: p_init_msg_list => FND_API.G_FALSE,
1516: p_commit => FND_API.G_FALSE);
1517:
1518: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1519:

Line 1516: p_commit => FND_API.G_FALSE);

1512: x_msg_count => l_msg_count,
1513: x_msg_data => l_msg_data,
1514: p_api_version => 1.0,
1515: p_init_msg_list => FND_API.G_FALSE,
1516: p_commit => FND_API.G_FALSE);
1517:
1518: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1519:
1520: l_token_tbl(1).token_name := 'Parent Object Id';

Line 1518: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

1514: p_api_version => 1.0,
1515: p_init_msg_list => FND_API.G_FALSE,
1516: p_commit => FND_API.G_FALSE);
1517:
1518: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1519:
1520: l_token_tbl(1).token_name := 'Parent Object Id';
1521: l_token_tbl(1).token_value := l_prior_object_id;
1522:

Line 1576: p_init_msg_list => FND_API.G_FALSE,

1572:
1573: EAM_WO_NETWORK_VALIDATE_PVT.Validate_Structure
1574: (
1575: p_api_version => 1.0,
1576: p_init_msg_list => FND_API.G_FALSE,
1577: p_commit => FND_API.G_FALSE,
1578: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1579:
1580: p_work_object_id => l_prior_object_id,

Line 1577: p_commit => FND_API.G_FALSE,

1573: EAM_WO_NETWORK_VALIDATE_PVT.Validate_Structure
1574: (
1575: p_api_version => 1.0,
1576: p_init_msg_list => FND_API.G_FALSE,
1577: p_commit => FND_API.G_FALSE,
1578: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1579:
1580: p_work_object_id => l_prior_object_id,
1581: p_work_object_type_id => l_prior_object_type_id,

Line 1578: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1574: (
1575: p_api_version => 1.0,
1576: p_init_msg_list => FND_API.G_FALSE,
1577: p_commit => FND_API.G_FALSE,
1578: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1579:
1580: p_work_object_id => l_prior_object_id,
1581: p_work_object_type_id => l_prior_object_type_id,
1582: p_exception_logging => 'Y',

Line 1594: IF l_return_status = FND_API.G_RET_STS_ERROR OR

1590: x_wo_relationship_exc_tbl => l_wo_relationship_exc_tbl
1591: );
1592:
1593:
1594: IF l_return_status = FND_API.G_RET_STS_ERROR OR
1595: l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1596:
1597: l_token_tbl(1).token_name := 'Prior_WorkOrder';
1598: l_token_tbl(1).token_value := l_prior_workorder;

Line 1595: l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1591: );
1592:
1593:
1594: IF l_return_status = FND_API.G_RET_STS_ERROR OR
1595: l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1596:
1597: l_token_tbl(1).token_name := 'Prior_WorkOrder';
1598: l_token_tbl(1).token_value := l_prior_workorder;
1599: l_token_tbl(2).token_name := 'Next_WorkOrder';

Line 1639: x_return_status := FND_API.G_RET_STS_ERROR;

1635: l_mesg_token_tbl := l_out_mesg_token_tbl;
1636:
1637: x_mesg_token_tbl := l_out_mesg_token_tbl;
1638:
1639: x_return_status := FND_API.G_RET_STS_ERROR;
1640: return;
1641:
1642: END Add_Dependency;
1643:

Line 1650: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1646:
1647: PROCEDURE Delink_Child_From_Parent
1648: (
1649: p_api_version IN NUMBER,
1650: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1651: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1652: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1653:
1654: p_child_object_id IN NUMBER,

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

1647: PROCEDURE Delink_Child_From_Parent
1648: (
1649: p_api_version IN NUMBER,
1650: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1651: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1652: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1653:
1654: p_child_object_id IN NUMBER,
1655: p_child_object_type_id IN NUMBER,

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

1648: (
1649: p_api_version IN NUMBER,
1650: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1651: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1652: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1653:
1654: p_child_object_id IN NUMBER,
1655: p_child_object_type_id IN NUMBER,
1656: p_parent_object_id IN NUMBER,

Line 1676: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

1672: l_parent_object_id NUMBER := p_parent_object_id;
1673: l_parent_object_type_id NUMBER := p_parent_object_type_id;
1674:
1675: l_relationship_status NUMBER := 0;
1676: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1677:
1678: l_sched_relationship_id NUMBER;
1679: l_msg_count NUMBER;
1680: l_msg_data VARCHAR2(1000);

Line 1717: x_return_status := FND_API.G_RET_STS_SUCCESS;

1713: BEGIN
1714:
1715: savepoint EAM_WN_DELINK_PAR_CH;
1716:
1717: x_return_status := FND_API.G_RET_STS_SUCCESS;
1718:
1719: SELECT wip_entity_name into l_parent_workorder
1720: FROM wip_entities we
1721: WHERE we.wip_entity_id = l_parent_object_id;

Line 1767: p_init_msg_list => FND_API.G_FALSE,

1763: x_return_status => l_return_status,
1764: x_msg_count => l_msg_count,
1765: x_msg_data => l_msg_data,
1766: p_api_version => 1.0,
1767: p_init_msg_list => FND_API.G_FALSE,
1768: p_commit => FND_API.G_FALSE);
1769:
1770: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1771:

Line 1768: p_commit => FND_API.G_FALSE);

1764: x_msg_count => l_msg_count,
1765: x_msg_data => l_msg_data,
1766: p_api_version => 1.0,
1767: p_init_msg_list => FND_API.G_FALSE,
1768: p_commit => FND_API.G_FALSE);
1769:
1770: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1771:
1772: l_token_tbl(1).token_name := 'Parent Object Id';

Line 1770: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

1766: p_api_version => 1.0,
1767: p_init_msg_list => FND_API.G_FALSE,
1768: p_commit => FND_API.G_FALSE);
1769:
1770: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1771:
1772: l_token_tbl(1).token_name := 'Parent Object Id';
1773: l_token_tbl(1).token_value := l_parent_object_id;
1774:

Line 1812: x_return_status := FND_API.G_RET_STS_ERROR;

1808: l_mesg_token_tbl := l_out_mesg_token_tbl;
1809:
1810: x_mesg_token_tbl := l_out_mesg_token_tbl;
1811:
1812: x_return_status := FND_API.G_RET_STS_ERROR;
1813: return;
1814: end if;
1815:
1816: IF l_relationship_type = 1 THEN

Line 1927: x_return_status := FND_API.G_RET_STS_ERROR;

1923: l_mesg_token_tbl := l_out_mesg_token_tbl;
1924:
1925: x_mesg_token_tbl := l_out_mesg_token_tbl;
1926:
1927: x_return_status := FND_API.G_RET_STS_ERROR;
1928: return;
1929:
1930: END Delink_Child_From_Parent;
1931:

Line 1941: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1937:
1938: PROCEDURE Check_Wo_Negative_Dates
1939: (
1940: p_api_version IN NUMBER,
1941: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1942: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1943: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1944: p_wip_entity_id IN NUMBER,
1945: p_organization_id IN NUMBER,

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

1938: PROCEDURE Check_Wo_Negative_Dates
1939: (
1940: p_api_version IN NUMBER,
1941: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1942: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1943: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1944: p_wip_entity_id IN NUMBER,
1945: p_organization_id IN NUMBER,
1946: x_return_status OUT NOCOPY VARCHAR2,

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

1939: (
1940: p_api_version IN NUMBER,
1941: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1942: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1943: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1944: p_wip_entity_id IN NUMBER,
1945: p_organization_id IN NUMBER,
1946: x_return_status OUT NOCOPY VARCHAR2,
1947: x_msg_count OUT NOCOPY NUMBER,

Line 2024: x_return_status := FND_API.G_RET_STS_ERROR;

2020:
2021:
2022: -- check if work order has -ve duration
2023: IF l_wo_start_date > l_wo_completion_date THEN
2024: x_return_status := FND_API.G_RET_STS_ERROR;
2025: RETURN;
2026: END IF;
2027:
2028:

Line 2045: x_return_status := FND_API.G_RET_STS_ERROR;

2041: LOOP FETCH l_op_records_cur into
2042: l_op_record;
2043:
2044: IF l_op_record.first_unit_start_date > l_op_record.last_unit_completion_date THEN
2045: x_return_status := FND_API.G_RET_STS_ERROR;
2046: RETURN;
2047: END IF;
2048:
2049: EXIT WHEN l_op_records_cur%NOTFOUND;

Line 2059: x_return_status := FND_API.G_RET_STS_ERROR;

2055: OPEN l_op_resources;
2056: LOOP FETCH l_op_resources into l_resource_record;
2057:
2058: IF l_resource_record.res_start_date > l_resource_record.res_completion_date THEN
2059: x_return_status := FND_API.G_RET_STS_ERROR;
2060: RETURN;
2061: END IF;
2062:
2063: EXIT WHEN l_op_resources%NOTFOUND;

Line 2073: x_return_status := FND_API.G_RET_STS_ERROR;

2069: OPEN l_resource_instances;
2070: LOOP FETCH l_resource_instances into l_resource_inst_record;
2071:
2072: IF l_resource_inst_record.resinst_start_date > l_resource_inst_record.resinst_completion_date THEN
2073: x_return_status := FND_API.G_RET_STS_ERROR;
2074: RETURN;
2075: END IF;
2076:
2077: EXIT WHEN l_resource_instances%NOTFOUND;

Line 2087: x_return_status := FND_API.G_RET_STS_ERROR;

2083: OPEN l_op_sub_resources;
2084: LOOP FETCH l_op_sub_resources into l_sub_resource_record;
2085:
2086: IF l_sub_resource_record.res_start_date > l_sub_resource_record.res_completion_date THEN
2087: x_return_status := FND_API.G_RET_STS_ERROR;
2088: RETURN;
2089: END IF;
2090:
2091: EXIT WHEN l_op_sub_resources%NOTFOUND;

Line 2097: x_return_status := FND_API.G_RET_STS_SUCCESS;

2093:
2094: CLOSE l_op_sub_resources;
2095:
2096:
2097: x_return_status := FND_API.G_RET_STS_SUCCESS;
2098:
2099: EXCEPTION
2100: when others then
2101: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2101: x_return_status := FND_API.G_RET_STS_ERROR;

2097: x_return_status := FND_API.G_RET_STS_SUCCESS;
2098:
2099: EXCEPTION
2100: when others then
2101: x_return_status := FND_API.G_RET_STS_ERROR;
2102: return;
2103:
2104: END Check_Wo_Negative_Dates;
2105:

Line 2113: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2109: -- This procedure can be used while moving or resizing work orders
2110: PROCEDURE Check_WO_Dates
2111: (
2112: p_api_version IN NUMBER,
2113: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2114: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2115: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2116:
2117: p_wip_entity_id IN NUMBER,

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

2110: PROCEDURE Check_WO_Dates
2111: (
2112: p_api_version IN NUMBER,
2113: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2114: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2115: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2116:
2117: p_wip_entity_id IN NUMBER,
2118:

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

2111: (
2112: p_api_version IN NUMBER,
2113: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2114: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2115: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2116:
2117: p_wip_entity_id IN NUMBER,
2118:
2119: x_return_status OUT NOCOPY VARCHAR2,

Line 2242: x_return_status := FND_API.G_RET_STS_ERROR;

2238: l_operation_record;
2239:
2240: IF l_operation_record.first_unit_start_date < l_wo_start_date OR
2241: l_operation_record.last_unit_completion_date > l_wo_completion_date THEN
2242: x_return_status := FND_API.G_RET_STS_ERROR;
2243: RETURN;
2244: END IF;
2245:
2246: EXIT WHEN l_wo_operations%NOTFOUND;

Line 2257: x_return_status := FND_API.G_RET_STS_ERROR;

2253: LOOP FETCH l_op_resources into l_resource_record;
2254:
2255: IF l_resource_record.res_start_date < l_resource_record.op_start_date OR
2256: l_resource_record.res_completion_date > l_resource_record.op_completion_date THEN
2257: x_return_status := FND_API.G_RET_STS_ERROR;
2258: RETURN;
2259: END IF;
2260:
2261: EXIT WHEN l_op_resources%NOTFOUND;

Line 2272: x_return_status := FND_API.G_RET_STS_ERROR;

2268: LOOP FETCH l_resource_instances into l_resource_inst_record;
2269:
2270: IF l_resource_inst_record.resinst_start_date < l_resource_inst_record.res_start_date OR
2271: l_resource_inst_record.resinst_completion_date > l_resource_inst_record.res_completion_date THEN
2272: x_return_status := FND_API.G_RET_STS_ERROR;
2273: RETURN;
2274: END IF;
2275:
2276: EXIT WHEN l_resource_instances%NOTFOUND;

Line 2287: x_return_status := FND_API.G_RET_STS_ERROR;

2283: LOOP FETCH l_res_usages into l_res_usages_record;
2284:
2285: IF l_res_usages_record.res_start_date > l_res_usages_record.res_usg_start_date OR
2286: l_res_usages_record.res_usg_completion_date > l_res_usages_record.res_completion_date THEN
2287: x_return_status := FND_API.G_RET_STS_ERROR;
2288: RETURN;
2289: END IF;
2290:
2291: EXIT WHEN l_res_usages%NOTFOUND;

Line 2302: x_return_status := FND_API.G_RET_STS_ERROR;

2298: LOOP FETCH l_res_usage_instances into l_res_usage_inst_record;
2299:
2300: IF l_res_usage_inst_record.resinst_start_date > l_res_usage_inst_record.res_usg_start_date OR
2301: l_res_usage_inst_record.res_usg_completion_date > l_res_usage_inst_record.resinst_completion_date THEN
2302: x_return_status := FND_API.G_RET_STS_ERROR;
2303: RETURN;
2304: END IF;
2305:
2306: EXIT WHEN l_res_usage_instances%NOTFOUND;

Line 2312: x_return_status := FND_API.G_RET_STS_SUCCESS;

2308:
2309: CLOSE l_res_usage_instances;
2310:
2311:
2312: x_return_status := FND_API.G_RET_STS_SUCCESS;
2313:
2314: EXCEPTION
2315: when others then
2316: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2316: x_return_status := FND_API.G_RET_STS_ERROR;

2312: x_return_status := FND_API.G_RET_STS_SUCCESS;
2313:
2314: EXCEPTION
2315: when others then
2316: x_return_status := FND_API.G_RET_STS_ERROR;
2317: return;
2318:
2319: END Check_WO_Dates;
2320:

Line 2325: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2321: -- To check dates of wori,woru,wor
2322: PROCEDURE Check_Resource_Dates
2323: (
2324: p_api_version IN NUMBER,
2325: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2326: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2327: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2328:
2329: p_wip_entity_id IN NUMBER,

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

2322: PROCEDURE Check_Resource_Dates
2323: (
2324: p_api_version IN NUMBER,
2325: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2326: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2327: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2328:
2329: p_wip_entity_id IN NUMBER,
2330:

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

2323: (
2324: p_api_version IN NUMBER,
2325: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2326: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2327: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2328:
2329: p_wip_entity_id IN NUMBER,
2330:
2331: x_return_status OUT NOCOPY VARCHAR2,

Line 2442: x_return_status := FND_API.G_RET_STS_SUCCESS;

2438: END LOOP;
2439:
2440: CLOSE l_res_usage_instances;
2441:
2442: x_return_status := FND_API.G_RET_STS_SUCCESS;
2443:
2444: EXCEPTION
2445: when others then
2446: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2446: x_return_status := FND_API.G_RET_STS_ERROR;

2442: x_return_status := FND_API.G_RET_STS_SUCCESS;
2443:
2444: EXCEPTION
2445: when others then
2446: x_return_status := FND_API.G_RET_STS_ERROR;
2447: return;
2448:
2449: END Check_Resource_Dates;
2450:

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

2463:
2464: PROCEDURE Snap_Right
2465: (
2466: p_api_version IN NUMBER,
2467: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
2468: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2469: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2470:
2471: p_work_object_id IN NUMBER,

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

2464: PROCEDURE Snap_Right
2465: (
2466: p_api_version IN NUMBER,
2467: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
2468: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2469: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2470:
2471: p_work_object_id IN NUMBER,
2472: p_work_object_type_id IN NUMBER,

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

2465: (
2466: p_api_version IN NUMBER,
2467: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
2468: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2469: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2470:
2471: p_work_object_id IN NUMBER,
2472: p_work_object_type_id IN NUMBER,
2473:

Line 2500: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

2496: BEGIN
2497: -- Standard Start of API savepoint
2498: SAVEPOINT EAM_WO_NETWORK_DEFAULT_PVT;
2499: -- Standard call to check for call compatibility.
2500: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
2501: p_api_version ,
2502: l_api_name ,
2503: G_PKG_NAME )
2504: THEN

Line 2505: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2501: p_api_version ,
2502: l_api_name ,
2503: G_PKG_NAME )
2504: THEN
2505: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2506: END IF;
2507: -- Initialize message list if p_init_msg_list is set to TRUE.
2508: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2509: FND_MSG_PUB.initialize;

Line 2508: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2504: THEN
2505: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2506: END IF;
2507: -- Initialize message list if p_init_msg_list is set to TRUE.
2508: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2509: FND_MSG_PUB.initialize;
2510: END IF;
2511: -- Initialize API return status to success
2512: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2512: x_return_status := FND_API.G_RET_STS_SUCCESS;

2508: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2509: FND_MSG_PUB.initialize;
2510: END IF;
2511: -- Initialize API return status to success
2512: x_return_status := FND_API.G_RET_STS_SUCCESS;
2513: -- API body
2514:
2515: /* Initialize the local variables */
2516: l_stmt_num := 10;

Line 2519: l_return_status := FND_API.G_RET_STS_SUCCESS;

2515: /* Initialize the local variables */
2516: l_stmt_num := 10;
2517: l_work_object_id := p_work_object_id;
2518: l_work_object_type_id := p_work_object_type_id;
2519: l_return_status := FND_API.G_RET_STS_SUCCESS;
2520: l_msg_count := 0 ;
2521: l_msg_data := NULL;
2522:
2523:

Line 2537: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

2533: x_msg_count => l_msg_count,
2534: x_msg_data => l_msg_data
2535: );
2536:
2537: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2538: x_return_status := FND_API.G_RET_STS_ERROR;
2539: RETURN;
2540:
2541: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2538: x_return_status := FND_API.G_RET_STS_ERROR;

2534: x_msg_data => l_msg_data
2535: );
2536:
2537: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2538: x_return_status := FND_API.G_RET_STS_ERROR;
2539: RETURN;
2540:
2541: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2541: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

2537: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2538: x_return_status := FND_API.G_RET_STS_ERROR;
2539: RETURN;
2540:
2541: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2543: RETURN;
2544: END IF;
2545:

Line 2542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2538: x_return_status := FND_API.G_RET_STS_ERROR;
2539: RETURN;
2540:
2541: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2543: RETURN;
2544: END IF;
2545:
2546: /* Initialize the local variables */

Line 2548: l_return_status := FND_API.G_RET_STS_SUCCESS;

2544: END IF;
2545:
2546: /* Initialize the local variables */
2547: l_stmt_num := 10;
2548: l_return_status := FND_API.G_RET_STS_SUCCESS;
2549: l_msg_count := 0 ;
2550: l_msg_data := NULL;
2551:
2552:

Line 2571: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

2567: x_msg_data => l_msg_data
2568:
2569: );
2570:
2571: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2572: x_return_status := FND_API.G_RET_STS_ERROR;
2573: RETURN;
2574:
2575: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2572: x_return_status := FND_API.G_RET_STS_ERROR;

2568:
2569: );
2570:
2571: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2572: x_return_status := FND_API.G_RET_STS_ERROR;
2573: RETURN;
2574:
2575: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2576: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2575: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

2571: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2572: x_return_status := FND_API.G_RET_STS_ERROR;
2573: RETURN;
2574:
2575: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2576: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2577: RETURN;
2578: END IF;
2579:

Line 2576: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2572: x_return_status := FND_API.G_RET_STS_ERROR;
2573: RETURN;
2574:
2575: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2576: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2577: RETURN;
2578: END IF;
2579:
2580:

Line 2584: IF FND_API.To_Boolean( p_commit ) THEN

2580:
2581:
2582: -- End of API body.
2583: -- Standard check of p_commit.
2584: IF FND_API.To_Boolean( p_commit ) THEN
2585: --dbms_output.put_line('committing');
2586: COMMIT WORK;
2587: END IF;
2588: -- Standard call to get message count and if count is 1, get message info.

Line 2594: WHEN FND_API.G_EXC_ERROR THEN

2590: ( p_count => x_msg_count ,
2591: p_data => x_msg_data
2592: );
2593: EXCEPTION
2594: WHEN FND_API.G_EXC_ERROR THEN
2595: x_return_status := FND_API.G_RET_STS_ERROR ;
2596: FND_MSG_PUB.Count_And_Get
2597: ( p_count => x_msg_count ,
2598: p_data => x_msg_data

Line 2595: x_return_status := FND_API.G_RET_STS_ERROR ;

2591: p_data => x_msg_data
2592: );
2593: EXCEPTION
2594: WHEN FND_API.G_EXC_ERROR THEN
2595: x_return_status := FND_API.G_RET_STS_ERROR ;
2596: FND_MSG_PUB.Count_And_Get
2597: ( p_count => x_msg_count ,
2598: p_data => x_msg_data
2599: );

Line 2602: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2598: p_data => x_msg_data
2599: );
2600:
2601:
2602: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2603: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2604: FND_MSG_PUB.Count_And_Get
2605: (
2606: p_count => x_msg_count,

Line 2603: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2599: );
2600:
2601:
2602: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2603: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2604: FND_MSG_PUB.Count_And_Get
2605: (
2606: p_count => x_msg_count,
2607: p_data => x_msg_data

Line 2611: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2607: p_data => x_msg_data
2608: );
2609:
2610: WHEN OTHERS THEN
2611: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2612: IF FND_MSG_PUB.Check_Msg_Level
2613: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2614: THEN
2615: FND_MSG_PUB.Add_Exc_Msg

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

2639:
2640: PROCEDURE Snap_Left
2641: (
2642: p_api_version IN NUMBER,
2643: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
2644: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2645: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2646:
2647: p_work_object_id IN NUMBER,

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

2640: PROCEDURE Snap_Left
2641: (
2642: p_api_version IN NUMBER,
2643: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
2644: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2645: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2646:
2647: p_work_object_id IN NUMBER,
2648: p_work_object_type_id IN NUMBER,

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

2641: (
2642: p_api_version IN NUMBER,
2643: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
2644: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2645: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2646:
2647: p_work_object_id IN NUMBER,
2648: p_work_object_type_id IN NUMBER,
2649:

Line 2676: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

2672: BEGIN
2673: -- Standard Start of API savepoint
2674: SAVEPOINT EAM_WO_NETWORK_DEFAULT_PVT;
2675: -- Standard call to check for call compatibility.
2676: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
2677: p_api_version ,
2678: l_api_name ,
2679: G_PKG_NAME )
2680: THEN

Line 2681: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2677: p_api_version ,
2678: l_api_name ,
2679: G_PKG_NAME )
2680: THEN
2681: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2682: END IF;
2683: -- Initialize message list if p_init_msg_list is set to TRUE.
2684: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2685: FND_MSG_PUB.initialize;

Line 2684: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2680: THEN
2681: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2682: END IF;
2683: -- Initialize message list if p_init_msg_list is set to TRUE.
2684: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2685: FND_MSG_PUB.initialize;
2686: END IF;
2687: -- Initialize API return status to success
2688: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2688: x_return_status := FND_API.G_RET_STS_SUCCESS;

2684: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2685: FND_MSG_PUB.initialize;
2686: END IF;
2687: -- Initialize API return status to success
2688: x_return_status := FND_API.G_RET_STS_SUCCESS;
2689: -- API body
2690:
2691: /* Initialize the local variables */
2692: l_stmt_num := 10;

Line 2696: l_return_status := FND_API.G_RET_STS_SUCCESS;

2692: l_stmt_num := 10;
2693: l_work_object_id := p_work_object_id;
2694: l_work_object_type_id := p_work_object_type_id;
2695: l_left_snap_window := 0;
2696: l_return_status := FND_API.G_RET_STS_SUCCESS;
2697: l_msg_count := 0 ;
2698: l_msg_data := NULL;
2699:
2700:

Line 2714: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

2710: x_msg_count => l_msg_count,
2711: x_msg_data => l_msg_data
2712: );
2713:
2714: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2715: x_return_status := FND_API.G_RET_STS_ERROR;
2716: RETURN;
2717:
2718: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2715: x_return_status := FND_API.G_RET_STS_ERROR;

2711: x_msg_data => l_msg_data
2712: );
2713:
2714: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2715: x_return_status := FND_API.G_RET_STS_ERROR;
2716: RETURN;
2717:
2718: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2718: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

2714: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2715: x_return_status := FND_API.G_RET_STS_ERROR;
2716: RETURN;
2717:
2718: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2720: RETURN;
2721: END IF;
2722:

Line 2719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2715: x_return_status := FND_API.G_RET_STS_ERROR;
2716: RETURN;
2717:
2718: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2720: RETURN;
2721: END IF;
2722:
2723: /* Initialize the local variables */

Line 2725: l_return_status := FND_API.G_RET_STS_SUCCESS;

2721: END IF;
2722:
2723: /* Initialize the local variables */
2724: l_stmt_num := 10;
2725: l_return_status := FND_API.G_RET_STS_SUCCESS;
2726: l_msg_count := 0 ;
2727: l_msg_data := NULL;
2728:
2729:

Line 2748: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

2744: x_msg_data => l_msg_data
2745:
2746: );
2747:
2748: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2749: x_return_status := FND_API.G_RET_STS_ERROR;
2750: RETURN;
2751:
2752: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2749: x_return_status := FND_API.G_RET_STS_ERROR;

2745:
2746: );
2747:
2748: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2749: x_return_status := FND_API.G_RET_STS_ERROR;
2750: RETURN;
2751:
2752: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2753: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2752: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

2748: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2749: x_return_status := FND_API.G_RET_STS_ERROR;
2750: RETURN;
2751:
2752: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2753: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2754: RETURN;
2755: END IF;
2756:

Line 2753: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2749: x_return_status := FND_API.G_RET_STS_ERROR;
2750: RETURN;
2751:
2752: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2753: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2754: RETURN;
2755: END IF;
2756:
2757:

Line 2761: IF FND_API.To_Boolean( p_commit ) THEN

2757:
2758:
2759: -- End of API body.
2760: -- Standard check of p_commit.
2761: IF FND_API.To_Boolean( p_commit ) THEN
2762: --dbms_output.put_line('committing');
2763: COMMIT WORK;
2764: END IF;
2765: -- Standard call to get message count and if count is 1, get message info.

Line 2771: WHEN FND_API.G_EXC_ERROR THEN

2767: ( p_count => x_msg_count ,
2768: p_data => x_msg_data
2769: );
2770: EXCEPTION
2771: WHEN FND_API.G_EXC_ERROR THEN
2772: x_return_status := FND_API.G_RET_STS_ERROR ;
2773: FND_MSG_PUB.Count_And_Get
2774: ( p_count => x_msg_count ,
2775: p_data => x_msg_data

Line 2772: x_return_status := FND_API.G_RET_STS_ERROR ;

2768: p_data => x_msg_data
2769: );
2770: EXCEPTION
2771: WHEN FND_API.G_EXC_ERROR THEN
2772: x_return_status := FND_API.G_RET_STS_ERROR ;
2773: FND_MSG_PUB.Count_And_Get
2774: ( p_count => x_msg_count ,
2775: p_data => x_msg_data
2776: );

Line 2779: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2775: p_data => x_msg_data
2776: );
2777:
2778:
2779: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2780: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2781: FND_MSG_PUB.Count_And_Get
2782: (
2783: p_count => x_msg_count,

Line 2780: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2776: );
2777:
2778:
2779: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2780: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2781: FND_MSG_PUB.Count_And_Get
2782: (
2783: p_count => x_msg_count,
2784: p_data => x_msg_data

Line 2788: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2784: p_data => x_msg_data
2785: );
2786:
2787: WHEN OTHERS THEN
2788: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2789: IF FND_MSG_PUB.Check_Msg_Level
2790: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2791: THEN
2792: FND_MSG_PUB.Add_Exc_Msg

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

2815: *********************************************************************/
2816: PROCEDURE Snap_Right_Window
2817: (
2818: p_api_version IN NUMBER,
2819: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
2820: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2821: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2822:
2823: p_work_object_id IN NUMBER,

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

2816: PROCEDURE Snap_Right_Window
2817: (
2818: p_api_version IN NUMBER,
2819: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
2820: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2821: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2822:
2823: p_work_object_id IN NUMBER,
2824: p_work_object_type_id IN NUMBER,

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

2817: (
2818: p_api_version IN NUMBER,
2819: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
2820: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2821: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2822:
2823: p_work_object_id IN NUMBER,
2824: p_work_object_type_id IN NUMBER,
2825:

Line 2859: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

2855: BEGIN
2856: -- Standard Start of API savepoint
2857: SAVEPOINT EAM_WO_NETWORK_DEFAULT_PVT;
2858: -- Standard call to check for call compatibility.
2859: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
2860: p_api_version ,
2861: l_api_name ,
2862: G_PKG_NAME )
2863: THEN

Line 2864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2860: p_api_version ,
2861: l_api_name ,
2862: G_PKG_NAME )
2863: THEN
2864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2865: END IF;
2866: -- Initialize message list if p_init_msg_list is set to TRUE.
2867: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2868: FND_MSG_PUB.initialize;

Line 2867: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2863: THEN
2864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2865: END IF;
2866: -- Initialize message list if p_init_msg_list is set to TRUE.
2867: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2868: FND_MSG_PUB.initialize;
2869: END IF;
2870: -- Initialize API return status to success
2871: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2871: x_return_status := FND_API.G_RET_STS_SUCCESS;

2867: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2868: FND_MSG_PUB.initialize;
2869: END IF;
2870: -- Initialize API return status to success
2871: x_return_status := FND_API.G_RET_STS_SUCCESS;
2872: -- API body
2873:
2874: /* Initialize the local variables */
2875: l_stmt_num := 10;

Line 3043: IF FND_API.To_Boolean( p_commit ) THEN

3039:
3040:
3041: -- End of API body.
3042: -- Standard check of p_commit.
3043: IF FND_API.To_Boolean( p_commit ) THEN
3044: --dbms_output.put_line('committing');
3045: COMMIT WORK;
3046: END IF;
3047: -- Standard call to get message count and if count is 1, get message info.

Line 3053: WHEN FND_API.G_EXC_ERROR THEN

3049: ( p_count => x_msg_count ,
3050: p_data => x_msg_data
3051: );
3052: EXCEPTION
3053: WHEN FND_API.G_EXC_ERROR THEN
3054: x_return_status := FND_API.G_RET_STS_ERROR ;
3055: FND_MSG_PUB.Count_And_Get
3056: ( p_count => x_msg_count ,
3057: p_data => x_msg_data

Line 3054: x_return_status := FND_API.G_RET_STS_ERROR ;

3050: p_data => x_msg_data
3051: );
3052: EXCEPTION
3053: WHEN FND_API.G_EXC_ERROR THEN
3054: x_return_status := FND_API.G_RET_STS_ERROR ;
3055: FND_MSG_PUB.Count_And_Get
3056: ( p_count => x_msg_count ,
3057: p_data => x_msg_data
3058: );

Line 3061: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3057: p_data => x_msg_data
3058: );
3059:
3060:
3061: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3062: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3063: FND_MSG_PUB.Count_And_Get
3064: (
3065: p_count => x_msg_count,

Line 3062: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3058: );
3059:
3060:
3061: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3062: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3063: FND_MSG_PUB.Count_And_Get
3064: (
3065: p_count => x_msg_count,
3066: p_data => x_msg_data

Line 3070: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3066: p_data => x_msg_data
3067: );
3068:
3069: WHEN OTHERS THEN
3070: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3071: IF FND_MSG_PUB.Check_Msg_Level
3072: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3073: THEN
3074: FND_MSG_PUB.Add_Exc_Msg

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

3098: *********************************************************************/
3099: PROCEDURE Snap_Left_Window
3100: (
3101: p_api_version IN NUMBER,
3102: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
3103: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3104: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3105:
3106: p_work_object_id IN NUMBER,

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

3099: PROCEDURE Snap_Left_Window
3100: (
3101: p_api_version IN NUMBER,
3102: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
3103: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3104: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3105:
3106: p_work_object_id IN NUMBER,
3107: p_work_object_type_id IN NUMBER,

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

3100: (
3101: p_api_version IN NUMBER,
3102: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
3103: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3104: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3105:
3106: p_work_object_id IN NUMBER,
3107: p_work_object_type_id IN NUMBER,
3108:

Line 3142: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

3138: BEGIN
3139: -- Standard Start of API savepoint
3140: SAVEPOINT EAM_WO_NETWORK_DEFAULT_PVT;
3141: -- Standard call to check for call compatibility.
3142: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
3143: p_api_version ,
3144: l_api_name ,
3145: G_PKG_NAME )
3146: THEN

Line 3147: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3143: p_api_version ,
3144: l_api_name ,
3145: G_PKG_NAME )
3146: THEN
3147: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3148: END IF;
3149: -- Initialize message list if p_init_msg_list is set to TRUE.
3150: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3151: FND_MSG_PUB.initialize;

Line 3150: IF FND_API.to_Boolean( p_init_msg_list ) THEN

3146: THEN
3147: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3148: END IF;
3149: -- Initialize message list if p_init_msg_list is set to TRUE.
3150: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3151: FND_MSG_PUB.initialize;
3152: END IF;
3153: -- Initialize API return status to success
3154: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3154: x_return_status := FND_API.G_RET_STS_SUCCESS;

3150: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3151: FND_MSG_PUB.initialize;
3152: END IF;
3153: -- Initialize API return status to success
3154: x_return_status := FND_API.G_RET_STS_SUCCESS;
3155: -- API body
3156:
3157: /* Initialize the local variables */
3158: l_stmt_num := 10;

Line 3324: IF FND_API.To_Boolean( p_commit ) THEN

3320:
3321:
3322: -- End of API body.
3323: -- Standard check of p_commit.
3324: IF FND_API.To_Boolean( p_commit ) THEN
3325: --dbms_output.put_line('committing');
3326: COMMIT WORK;
3327: END IF;
3328: -- Standard call to get message count and if count is 1, get message info.

Line 3334: WHEN FND_API.G_EXC_ERROR THEN

3330: ( p_count => x_msg_count ,
3331: p_data => x_msg_data
3332: );
3333: EXCEPTION
3334: WHEN FND_API.G_EXC_ERROR THEN
3335: x_return_status := FND_API.G_RET_STS_ERROR ;
3336: FND_MSG_PUB.Count_And_Get
3337: ( p_count => x_msg_count ,
3338: p_data => x_msg_data

Line 3335: x_return_status := FND_API.G_RET_STS_ERROR ;

3331: p_data => x_msg_data
3332: );
3333: EXCEPTION
3334: WHEN FND_API.G_EXC_ERROR THEN
3335: x_return_status := FND_API.G_RET_STS_ERROR ;
3336: FND_MSG_PUB.Count_And_Get
3337: ( p_count => x_msg_count ,
3338: p_data => x_msg_data
3339: );

Line 3342: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3338: p_data => x_msg_data
3339: );
3340:
3341:
3342: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3343: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3344: FND_MSG_PUB.Count_And_Get
3345: (
3346: p_count => x_msg_count,

Line 3343: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3339: );
3340:
3341:
3342: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3343: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3344: FND_MSG_PUB.Count_And_Get
3345: (
3346: p_count => x_msg_count,
3347: p_data => x_msg_data

Line 3351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3347: p_data => x_msg_data
3348: );
3349:
3350: WHEN OTHERS THEN
3351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3352: IF FND_MSG_PUB.Check_Msg_Level
3353: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3354: THEN
3355: FND_MSG_PUB.Add_Exc_Msg

Line 3385: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

3381:
3382: PROCEDURE Find_Right_Snap_Window
3383: (
3384: p_api_version IN NUMBER,
3385: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3386: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3387: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3388:
3389: p_starting_object_id IN NUMBER,

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

3382: PROCEDURE Find_Right_Snap_Window
3383: (
3384: p_api_version IN NUMBER,
3385: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3386: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3387: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3388:
3389: p_starting_object_id IN NUMBER,
3390: p_starting_obj_type_id IN NUMBER,

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

3383: (
3384: p_api_version IN NUMBER,
3385: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3386: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3387: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3388:
3389: p_starting_object_id IN NUMBER,
3390: p_starting_obj_type_id IN NUMBER,
3391: p_parent_object_id IN NUMBER,

Line 3435: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

3431: BEGIN
3432: -- Standard Start of API savepoint
3433:
3434: -- Standard call to check for call compatibility.
3435: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
3436: p_api_version ,
3437: l_api_name ,
3438: G_PKG_NAME )
3439: THEN

Line 3440: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3436: p_api_version ,
3437: l_api_name ,
3438: G_PKG_NAME )
3439: THEN
3440: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3441: END IF;
3442: -- Initialize message list if p_init_msg_list is set to TRUE.
3443: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3444: FND_MSG_PUB.initialize;

Line 3443: IF FND_API.to_Boolean( p_init_msg_list ) THEN

3439: THEN
3440: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3441: END IF;
3442: -- Initialize message list if p_init_msg_list is set to TRUE.
3443: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3444: FND_MSG_PUB.initialize;
3445: END IF;
3446: -- Initialize API return status to success
3447: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3447: x_return_status := FND_API.G_RET_STS_SUCCESS;

3443: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3444: FND_MSG_PUB.initialize;
3445: END IF;
3446: -- Initialize API return status to success
3447: x_return_status := FND_API.G_RET_STS_SUCCESS;
3448: -- API body
3449:
3450: /* Initialize the local variables */
3451: l_stmt_num := 10;

Line 3548: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

3544: x_msg_count => l_msg_count,
3545: x_msg_data => l_msg_data
3546: );
3547:
3548: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
3549: x_return_status := FND_API.G_RET_STS_ERROR;
3550:
3551: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3552: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3549: x_return_status := FND_API.G_RET_STS_ERROR;

3545: x_msg_data => l_msg_data
3546: );
3547:
3548: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
3549: x_return_status := FND_API.G_RET_STS_ERROR;
3550:
3551: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3552: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3553:

Line 3551: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

3547:
3548: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
3549: x_return_status := FND_API.G_RET_STS_ERROR;
3550:
3551: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3552: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3553:
3554: END IF;
3555:

Line 3552: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3548: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
3549: x_return_status := FND_API.G_RET_STS_ERROR;
3550:
3551: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3552: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3553:
3554: END IF;
3555:
3556:

Line 3574: IF FND_API.To_Boolean( p_commit ) THEN

3570: */
3571:
3572: -- End of API body.
3573: -- Standard check of p_commit.
3574: IF FND_API.To_Boolean( p_commit ) THEN
3575: --dbms_output.put_line('committing');
3576: COMMIT WORK;
3577: END IF;
3578: -- Standard call to get message count and if count is 1, get message info.

Line 3584: WHEN FND_API.G_EXC_ERROR THEN

3580: ( p_count => x_msg_count ,
3581: p_data => x_msg_data
3582: );
3583: EXCEPTION
3584: WHEN FND_API.G_EXC_ERROR THEN
3585: x_return_status := FND_API.G_RET_STS_ERROR ;
3586: FND_MSG_PUB.Count_And_Get
3587: ( p_count => x_msg_count ,
3588: p_data => x_msg_data

Line 3585: x_return_status := FND_API.G_RET_STS_ERROR ;

3581: p_data => x_msg_data
3582: );
3583: EXCEPTION
3584: WHEN FND_API.G_EXC_ERROR THEN
3585: x_return_status := FND_API.G_RET_STS_ERROR ;
3586: FND_MSG_PUB.Count_And_Get
3587: ( p_count => x_msg_count ,
3588: p_data => x_msg_data
3589: );

Line 3592: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3588: p_data => x_msg_data
3589: );
3590:
3591: RETURN;
3592: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3593:
3594: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3595: FND_MSG_PUB.Count_And_Get
3596: (

Line 3594: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3590:
3591: RETURN;
3592: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3593:
3594: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3595: FND_MSG_PUB.Count_And_Get
3596: (
3597: p_count => x_msg_count,
3598: p_data => x_msg_data

Line 3603: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3599: );
3600:
3601: RETURN;
3602: WHEN OTHERS THEN
3603: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3604: IF FND_MSG_PUB.Check_Msg_Level
3605: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3606: THEN
3607: FND_MSG_PUB.Add_Exc_Msg

Line 3639: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

3635:
3636: PROCEDURE Find_Left_Snap_Window
3637: (
3638: p_api_version IN NUMBER,
3639: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3640: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3641: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3642:
3643: p_starting_object_id IN NUMBER,

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

3636: PROCEDURE Find_Left_Snap_Window
3637: (
3638: p_api_version IN NUMBER,
3639: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3640: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3641: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3642:
3643: p_starting_object_id IN NUMBER,
3644: p_starting_obj_type_id IN NUMBER,

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

3637: (
3638: p_api_version IN NUMBER,
3639: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3640: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3641: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3642:
3643: p_starting_object_id IN NUMBER,
3644: p_starting_obj_type_id IN NUMBER,
3645: p_parent_object_id IN NUMBER,

Line 3689: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

3685: BEGIN
3686: -- Standard Start of API savepoint
3687:
3688: -- Standard call to check for call compatibility.
3689: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
3690: p_api_version ,
3691: l_api_name ,
3692: G_PKG_NAME )
3693: THEN

Line 3694: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3690: p_api_version ,
3691: l_api_name ,
3692: G_PKG_NAME )
3693: THEN
3694: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3695: END IF;
3696: -- Initialize message list if p_init_msg_list is set to TRUE.
3697: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3698: FND_MSG_PUB.initialize;

Line 3697: IF FND_API.to_Boolean( p_init_msg_list ) THEN

3693: THEN
3694: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3695: END IF;
3696: -- Initialize message list if p_init_msg_list is set to TRUE.
3697: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3698: FND_MSG_PUB.initialize;
3699: END IF;
3700: -- Initialize API return status to success
3701: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3701: x_return_status := FND_API.G_RET_STS_SUCCESS;

3697: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3698: FND_MSG_PUB.initialize;
3699: END IF;
3700: -- Initialize API return status to success
3701: x_return_status := FND_API.G_RET_STS_SUCCESS;
3702: -- API body
3703:
3704: /* Initialize the local variables */
3705: l_stmt_num := 10;

Line 3802: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

3798: x_msg_count => l_msg_count,
3799: x_msg_data => l_msg_data
3800: );
3801:
3802: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
3803: x_return_status := FND_API.G_RET_STS_ERROR;
3804:
3805: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3806: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3803: x_return_status := FND_API.G_RET_STS_ERROR;

3799: x_msg_data => l_msg_data
3800: );
3801:
3802: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
3803: x_return_status := FND_API.G_RET_STS_ERROR;
3804:
3805: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3806: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3807:

Line 3805: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

3801:
3802: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
3803: x_return_status := FND_API.G_RET_STS_ERROR;
3804:
3805: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3806: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3807:
3808: END IF;
3809:

Line 3806: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3802: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
3803: x_return_status := FND_API.G_RET_STS_ERROR;
3804:
3805: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3806: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3807:
3808: END IF;
3809:
3810:

Line 3829: IF FND_API.To_Boolean( p_commit ) THEN

3825:
3826:
3827: -- End of API body.
3828: -- Standard check of p_commit.
3829: IF FND_API.To_Boolean( p_commit ) THEN
3830: --dbms_output.put_line('committing');
3831: COMMIT WORK;
3832: END IF;
3833: -- Standard call to get message count and if count is 1, get message info.

Line 3839: WHEN FND_API.G_EXC_ERROR THEN

3835: ( p_count => x_msg_count ,
3836: p_data => x_msg_data
3837: );
3838: EXCEPTION
3839: WHEN FND_API.G_EXC_ERROR THEN
3840: x_return_status := FND_API.G_RET_STS_ERROR ;
3841: FND_MSG_PUB.Count_And_Get
3842: ( p_count => x_msg_count ,
3843: p_data => x_msg_data

Line 3840: x_return_status := FND_API.G_RET_STS_ERROR ;

3836: p_data => x_msg_data
3837: );
3838: EXCEPTION
3839: WHEN FND_API.G_EXC_ERROR THEN
3840: x_return_status := FND_API.G_RET_STS_ERROR ;
3841: FND_MSG_PUB.Count_And_Get
3842: ( p_count => x_msg_count ,
3843: p_data => x_msg_data
3844: );

Line 3847: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3843: p_data => x_msg_data
3844: );
3845:
3846: RETURN;
3847: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3848:
3849: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3850: FND_MSG_PUB.Count_And_Get
3851: (

Line 3849: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3845:
3846: RETURN;
3847: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3848:
3849: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3850: FND_MSG_PUB.Count_And_Get
3851: (
3852: p_count => x_msg_count,
3853: p_data => x_msg_data

Line 3858: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3854: );
3855:
3856: RETURN;
3857: WHEN OTHERS THEN
3858: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3859: IF FND_MSG_PUB.Check_Msg_Level
3860: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3861: THEN
3862: FND_MSG_PUB.Add_Exc_Msg