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

Line 120: ,p_Init_Msg_List => FND_API.G_TRUE

116: l_line_tbl(1) := l_line_rec;
117:
118: --we would call with true commit flag
119: CSP_PARTS_REQUIREMENT.process_requirement(p_api_version => 1.0
120: ,p_Init_Msg_List => FND_API.G_TRUE
121: ,p_commit => FND_API.G_TRUE
122: ,px_header_rec => l_header_rec
123: ,px_line_table => l_Line_Tbl
124: ,p_create_order_flag => 'Y'

Line 121: ,p_commit => FND_API.G_TRUE

117:
118: --we would call with true commit flag
119: CSP_PARTS_REQUIREMENT.process_requirement(p_api_version => 1.0
120: ,p_Init_Msg_List => FND_API.G_TRUE
121: ,p_commit => FND_API.G_TRUE
122: ,px_header_rec => l_header_rec
123: ,px_line_table => l_Line_Tbl
124: ,p_create_order_flag => 'Y'
125: ,x_return_status => l_return_Status

Line 130: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

126: ,x_msg_count => l_msg_count
127: ,x_msg_data => l_msg_data
128: );
129:
130: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
131: x_return_status := 'E';
132: x_error_msg := l_msg_data;
133:
134: -- This if is only for the Debug purpose

Line 140: , p_encoded => FND_API.G_FALSE

136: FOR l_counter IN 1 .. l_msg_count
137: LOOP
138: fnd_msg_pub.get
139: ( p_msg_index => l_counter
140: , p_encoded => FND_API.G_FALSE
141: , p_data => l_msg_data
142: , p_msg_index_out => l_msg_count
143: );
144: END LOOP;

Line 276: ,p_Init_Msg_List => FND_API.G_TRUE

272:
273:
274: --CSP_PARTS_ORDER.process_order(p_api_version => 1.0
275: CSP_PARTS_REQUIREMENT.process_requirement(p_api_version => 1.0
276: ,p_Init_Msg_List => FND_API.G_TRUE
277: ,p_commit => FND_API.G_TRUE
278: ,px_header_rec => l_header_rec
279: ,px_line_table => l_Line_Tbl
280: ,p_create_order_flag => 'Y'

Line 277: ,p_commit => FND_API.G_TRUE

273:
274: --CSP_PARTS_ORDER.process_order(p_api_version => 1.0
275: CSP_PARTS_REQUIREMENT.process_requirement(p_api_version => 1.0
276: ,p_Init_Msg_List => FND_API.G_TRUE
277: ,p_commit => FND_API.G_TRUE
278: ,px_header_rec => l_header_rec
279: ,px_line_table => l_Line_Tbl
280: ,p_create_order_flag => 'Y'
281: ,x_return_status => l_return_Status

Line 286: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

282: ,x_msg_count => l_msg_count
283: ,x_msg_data => l_msg_data
284: );
285:
286: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
287: x_return_status := 'E';
288: x_error_msg := l_msg_data;
289:
290: -- This if is only for the Debug purpose

Line 296: , p_encoded => FND_API.G_FALSE

292: FOR l_counter IN 1 .. l_msg_count
293: LOOP
294: fnd_msg_pub.get
295: ( p_msg_index => l_counter
296: , p_encoded => FND_API.G_FALSE
297: , p_data => l_msg_data
298: , p_msg_index_out => l_msg_count
299: );
300: END LOOP;

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

349: ,x_msg_count OUT NOCOPY NUMBER
350: ,x_msg_data OUT NOCOPY VARCHAR2 ) IS
351:
352: l_api_version_number CONSTANT NUMBER := 1.0;
353: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
354: l_msg_count NUMBER;
355: l_msg_data VARCHAR2(240);
356: l_commit VARCHAR2(1) := FND_API.G_FALSE;
357: l_move_order_id number;

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

352: l_api_version_number CONSTANT NUMBER := 1.0;
353: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
354: l_msg_count NUMBER;
355: l_msg_data VARCHAR2(240);
356: l_commit VARCHAR2(1) := FND_API.G_FALSE;
357: l_move_order_id number;
358: lx_line_id number;
359: l_api_name CONSTANT VARCHAR2(30) := 'CSFW.Create_Move_Order';
360: l_locator_id_to number;

Line 433: ,p_Init_Msg_List => FND_API.G_FALSE

429: CSP_TRANSACTIONS_PUB.CREATE_MOVE_ORDER_HEADER(
430: px_header_id => l_move_order_id
431: ,p_request_number => null
432: ,p_api_version => l_api_version_number
433: ,p_Init_Msg_List => FND_API.G_FALSE
434: ,p_commit => l_commit
435: ,p_date_required => l_date_required
436: ,p_organization_id => p_organization_id
437: ,p_from_subinventory_code => p_from_subinventory_code

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

451: ,x_return_status => l_return_status
452: ,x_msg_count => l_msg_count
453: ,x_msg_data => l_msg_data );
454:
455: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
456:
457: -- bug # 5171584
458: fnd_msg_pub.get
459: ( p_msg_index => l_msg_count

Line 460: , p_encoded => FND_API.G_FALSE

456:
457: -- bug # 5171584
458: fnd_msg_pub.get
459: ( p_msg_index => l_msg_count
460: , p_encoded => FND_API.G_FALSE
461: , p_data => x_msg_data
462: , p_msg_index_out => l_msg_count2
463: );
464:

Line 465: RAISE FND_API.G_EXC_ERROR;

461: , p_data => x_msg_data
462: , p_msg_index_out => l_msg_count2
463: );
464:
465: RAISE FND_API.G_EXC_ERROR;
466: ELSE
467:
468: --call the Line
469: CSP_TRANSACTIONS_PUB.CREATE_MOVE_ORDER_LINE

Line 471: ,p_Init_Msg_List => FND_API.G_FALSE

467:
468: --call the Line
469: CSP_TRANSACTIONS_PUB.CREATE_MOVE_ORDER_LINE
470: (p_api_version => l_api_version_number
471: ,p_Init_Msg_List => FND_API.G_FALSE
472: ,p_commit => FND_API.G_FALSE
473: ,px_line_id => lx_line_id
474: ,p_header_id => l_move_order_id
475: ,p_organization_id => p_organization_id

Line 472: ,p_commit => FND_API.G_FALSE

468: --call the Line
469: CSP_TRANSACTIONS_PUB.CREATE_MOVE_ORDER_LINE
470: (p_api_version => l_api_version_number
471: ,p_Init_Msg_List => FND_API.G_FALSE
472: ,p_commit => FND_API.G_FALSE
473: ,px_line_id => lx_line_id
474: ,p_header_id => l_move_order_id
475: ,p_organization_id => p_organization_id
476: ,p_from_subinventory_code => p_from_subinventory_code

Line 500: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

496: ,x_msg_count => l_msg_count
497: ,x_msg_data => l_msg_data ) ;
498:
499:
500: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
501:
502: -- bug # 5171584
503: fnd_msg_pub.get
504: ( p_msg_index => l_msg_count

Line 505: , p_encoded => FND_API.G_FALSE

501:
502: -- bug # 5171584
503: fnd_msg_pub.get
504: ( p_msg_index => l_msg_count
505: , p_encoded => FND_API.G_FALSE
506: , p_data => x_msg_data
507: , p_msg_index_out => l_msg_count2
508: );
509:

Line 510: RAISE FND_API.G_EXC_ERROR;

506: , p_data => x_msg_data
507: , p_msg_index_out => l_msg_count2
508: );
509:
510: RAISE FND_API.G_EXC_ERROR;
511: ELSE
512: x_return_status := FND_API.G_RET_STS_SUCCESS ;
513: COMMIT WORK;
514: open c_REQUEST_NUMBER(l_move_order_id);

Line 512: x_return_status := FND_API.G_RET_STS_SUCCESS ;

508: );
509:
510: RAISE FND_API.G_EXC_ERROR;
511: ELSE
512: x_return_status := FND_API.G_RET_STS_SUCCESS ;
513: COMMIT WORK;
514: open c_REQUEST_NUMBER(l_move_order_id);
515: fetch c_REQUEST_NUMBER into x_move_order_number;
516: close c_REQUEST_NUMBER;

Line 523: x_return_status := FND_API.G_RET_STS_ERROR;

519: END IF;
520:
521: EXCEPTION
522: WHEN OTHERS THEN
523: x_return_status := FND_API.G_RET_STS_ERROR;
524:
525: END CREATE_MOVE_ORDER;
526:
527:

Line 643: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

639: ,x_msg_count => x_msg_count
640: ,x_msg_data => l_msg_data);
641:
642: -- Bug 5465343: returning messages from TRANSACT_MATERIAL
643: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
644: x_return_status := l_return_status;
645: x_msg_count := l_msg_count;
646: x_msg_data := l_msg_data;
647: RAISE FND_API.G_EXC_ERROR;

Line 647: RAISE FND_API.G_EXC_ERROR;

643: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
644: x_return_status := l_return_status;
645: x_msg_count := l_msg_count;
646: x_msg_data := l_msg_data;
647: RAISE FND_API.G_EXC_ERROR;
648: ELSE
649: x_return_status := FND_API.G_RET_STS_SUCCESS ;
650: x_msg_count := 0;
651: x_msg_data := 'Success';

Line 649: x_return_status := FND_API.G_RET_STS_SUCCESS ;

645: x_msg_count := l_msg_count;
646: x_msg_data := l_msg_data;
647: RAISE FND_API.G_EXC_ERROR;
648: ELSE
649: x_return_status := FND_API.G_RET_STS_SUCCESS ;
650: x_msg_count := 0;
651: x_msg_data := 'Success';
652: END IF;
653:

Line 656: x_return_status := FND_API.G_RET_STS_ERROR;

652: END IF;
653:
654: EXCEPTION
655: WHEN OTHERS THEN
656: x_return_status := FND_API.G_RET_STS_ERROR;
657: END TRANSACT_MOVE_ORDER;
658:
659:
660:

Line 825: ,P_init_Msg_List => FND_API.G_TRUE

821: end loop;
822: --Now Lets Call The API
823: csp_receive_pvt.receive_shipments
824: (P_Api_Version_Number => 1.0
825: ,P_init_Msg_List => FND_API.G_TRUE
826: ,P_Commit => FND_API.G_TRUE
827: ,P_Validation_Level => FND_API.G_VALID_LEVEL_FULL
828: ,p_receive_hdr_rec => hdrrec
829: ,p_receive_rec_tbl => receiveRec

Line 826: ,P_Commit => FND_API.G_TRUE

822: --Now Lets Call The API
823: csp_receive_pvt.receive_shipments
824: (P_Api_Version_Number => 1.0
825: ,P_init_Msg_List => FND_API.G_TRUE
826: ,P_Commit => FND_API.G_TRUE
827: ,P_Validation_Level => FND_API.G_VALID_LEVEL_FULL
828: ,p_receive_hdr_rec => hdrrec
829: ,p_receive_rec_tbl => receiveRec
830: ,X_Return_Status => x_return_status

Line 827: ,P_Validation_Level => FND_API.G_VALID_LEVEL_FULL

823: csp_receive_pvt.receive_shipments
824: (P_Api_Version_Number => 1.0
825: ,P_init_Msg_List => FND_API.G_TRUE
826: ,P_Commit => FND_API.G_TRUE
827: ,P_Validation_Level => FND_API.G_VALID_LEVEL_FULL
828: ,p_receive_hdr_rec => hdrrec
829: ,p_receive_rec_tbl => receiveRec
830: ,X_Return_Status => x_return_status
831: ,X_Msg_Count => x_msg_count

Line 834: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

830: ,X_Return_Status => x_return_status
831: ,X_Msg_Count => x_msg_count
832: ,X_Msg_Data => x_msg_data);
833:
834: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
835: x_return_status := x_return_status;
836: x_msg_data := x_Msg_Data;
837: if x_msg_count > 0 THEN
838: FOR l_counter IN 1 .. x_msg_count

Line 842: , p_encoded => FND_API.G_FALSE

838: FOR l_counter IN 1 .. x_msg_count
839: LOOP
840: fnd_msg_pub.get
841: ( p_msg_index => l_counter
842: , p_encoded => FND_API.G_FALSE
843: , p_data => x_msg_data
844: , p_msg_index_out => x_msg_count
845: );
846: END LOOP;

Line 852: WHEN FND_API.G_EXC_ERROR THEN

848: end if;
849: END IF;
850:
851: EXCEPTION
852: WHEN FND_API.G_EXC_ERROR THEN
853: x_return_status := FND_API.G_RET_STS_ERROR;
854: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
855: P_API_NAME => L_API_NAME
856: ,P_PKG_NAME => G_PKG_NAME

Line 853: x_return_status := FND_API.G_RET_STS_ERROR;

849: END IF;
850:
851: EXCEPTION
852: WHEN FND_API.G_EXC_ERROR THEN
853: x_return_status := FND_API.G_RET_STS_ERROR;
854: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
855: P_API_NAME => L_API_NAME
856: ,P_PKG_NAME => G_PKG_NAME
857: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 862: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

858: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
859: ,X_MSG_COUNT => X_MSG_COUNT
860: ,X_MSG_DATA => X_MESSAGE
861: ,X_RETURN_STATUS => X_RETURN_STATUS);
862: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
863: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
864: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
865: P_API_NAME => L_API_NAME
866: ,P_PKG_NAME => G_PKG_NAME

Line 863: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

859: ,X_MSG_COUNT => X_MSG_COUNT
860: ,X_MSG_DATA => X_MESSAGE
861: ,X_RETURN_STATUS => X_RETURN_STATUS);
862: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
863: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
864: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
865: P_API_NAME => L_API_NAME
866: ,P_PKG_NAME => G_PKG_NAME
867: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 873: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

869: ,X_MSG_COUNT => X_MSG_COUNT
870: ,X_MSG_DATA => X_MESSAGE
871: ,X_RETURN_STATUS => X_RETURN_STATUS);
872: WHEN OTHERS THEN
873: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
874: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
875: P_API_NAME => L_API_NAME
876: ,P_PKG_NAME => G_PKG_NAME
877: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS